CombBox data
CombBox data
(OP)
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.
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.





RE: CombBox data
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: CombBox data
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.
RE: CombBox data
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk