CombBox data

[bpeirson]

I have a form for an Excel workbook with a list which will change periodically. My textbook on VBA notes that the data for the comboBox can be linked to spreadsheet data but does not describe how to do this.

I am going to write some code to open a specific workbook and tranfer the data in the workbook to the comboBox but I was hoping that there would be a shortcut for this already in place.

Thanks.

 

[johnwm]

In design mode right-click on the ComboBox and select Properties. Look for the ListFillRange property and set it to the range containing the values you want in the ComboBox. The selected value will be returned to the cell in the LinkedCell property

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

UK steam enthusiasts:

http://www.essexsteam.co.uk

 

[bpeirson]

I do not have that property available to me. There doesn't seem to be any choice in the properties window which would do what I need.

I did manage to write a simple loop which inserts the values needed, but the loop I wrote seems to be an awkward solution to a simple problem.

The most complicated thing about this is that some of the data I have to paste into the combobox is located in a different workbook.

Thanks.

 

[johnwm]

What version of Excel are you using?

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

UK steam enthusiasts:

http://www.essexsteam.co.uk