Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Visual Basic forms
Please Help,
There must be a million references to what I'm asking but I can't seem to find it. All I'd like to do is create a form in Visual Basics which contains a combo box, aka a dropdown list, but I am having a difficult time trying to figure out how to tie in the data into the combo box which would of course display the list. Can someone please help. Your help will be greatly appreciated. Is there a way to call the information from a current list on a worksheet? If so how? But it needs to be in VBA. |
#2
|
|||
|
|||
Set the Combo's RowSource property to the address of the worksheet range
holding the list. -- HTH RP (remove nothere from the email address if mailing direct) "tamato43" wrote in message ... Please Help, There must be a million references to what I'm asking but I can't seem to find it. All I'd like to do is create a form in Visual Basics which contains a combo box, aka a dropdown list, but I am having a difficult time trying to figure out how to tie in the data into the combo box which would of course display the list. Can someone please help. Your help will be greatly appreciated. Is there a way to call the information from a current list on a worksheet? If so how? But it needs to be in VBA. |
#3
|
|||
|
|||
Thank you!
"Bob Phillips" wrote: Set the Combo's RowSource property to the address of the worksheet range holding the list. -- HTH RP (remove nothere from the email address if mailing direct) "tamato43" wrote in message ... Please Help, There must be a million references to what I'm asking but I can't seem to find it. All I'd like to do is create a form in Visual Basics which contains a combo box, aka a dropdown list, but I am having a difficult time trying to figure out how to tie in the data into the combo box which would of course display the list. Can someone please help. Your help will be greatly appreciated. Is there a way to call the information from a current list on a worksheet? If so how? But it needs to be in VBA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the color of a Series Collection using visual basic? | Charts and Charting in Excel | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
Visual Basic Error Message | Excel Discussion (Misc queries) | |||
Excel version identification from Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic Code Remains in "memory" | Excel Worksheet Functions |