Hi Thanks for the reply. The form i am editing / creating is part of Excel.. to get to it TOOLS - MACRO - VISUAL BASIC EDITOR I have some screen shots of the form running and also of the form in VB Editor but cant find how to send these to this group to help explain better ? If this is possible could you let me know how to do this ? Kind regards Andy a...@amwarkup.co.uk
On Jan 28, 2:00 pm, Paul Schreiner <schreiner_p...@att.net> wrote: > First of all, you've not asked a question. > You have a scrollable box that displays up to 50 entries, > you have an Excel file with 200 items to diaplay in the scoll box. > > in a userform, a scrollbox is a box that can have a large number of entries, > and the "scroll" portion allows the user to see the entries that are not > displayed. > > Seems like "all is right with the world"... > so what's the problem? > > also, I'm confused about your terminology. > Microsoft has three distinct products called: > Visual Basic (VB) > Visual Basic Script (VBS) > Visual Basic for Applications (VBA) > > VBA runs within excel and can have userforms. > Visual Basic runs in Windows and can have userforms. > Visual Basic Script runs in Windows and DOES NOT have userforms, and > generally isn't the > best application to use to create "menus" (no checkboxes, or option buttons. > just yes/no/cancel/abort/retry) > > You said that you're using visual basic script to form a "menu" at the top of > your "screen". > "menu's" are generally part of the toolbar of an Application, not at the top > of the "screen", > > So, are you really using VBA to create a scrollable menu item in the Excel > toolbar? > > and once again, if the item is scrollable, WHY would you want it to show 200 > items all at once? > > I think we need some clarification (or at least *I* do!) > > sorry, > > Paul > > ________________________________ > From: andyfloyd <a...@amwarkup.co.uk> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Thu, January 28, 2010 3:45:14 AM > Subject: $$Excel-Macros$$ Forms in Visual basic scroll bar problem > > Hi all, new to this group so please bear with me. > The question I have is this... > I have a spreadsheet with several pages each with a list of components > on them. > I then have a visual basic script to form a menu at the top of my > screen which allows it to call up a form for users to fill in details > and select items from a form page to create the spreadsheet. > The problem I have is for instance:- > Page 1 on my spreadsheet has 200 items on it > Page 1 on my form to fill in has a scroll box which only allows it to > view around 50 lines ???? > Any ideas? A screen shot can be taken of the form or I can send the > spreadsheet to anyone who can help > Kind regards in anticipation > Andy > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads > athttp://www.excelitems.com > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe