ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Visual Basic forms (https://www.excelbanter.com/excel-discussion-misc-queries/19609-visual-basic-forms.html)

tamato43

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.





Bob Phillips

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.







tamato43

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.









All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com