daniels012
Well-known Member
- Joined
- Jan 13, 2005
- Messages
- 5,219
I am attempting to create a user form.
I have created 8 option boxes on my user form.
I have a combobox created on my user form.
Can I add code the when I select option1, it would give me the data from my "Sheet1('sheet1's name is RB) Column C" into my combo box.
Then if I select option2 Sheet2('Sheet2's name is WR) Column C would enter into the combobox.
I have code written that once I choose the item in the combo box, it then places the info into the active cell.
I already thought about making a master list with all the data from all the sheets, but I really would rather them be separate.
Thank you,
Michael
I have created 8 option boxes on my user form.
I have a combobox created on my user form.
Can I add code the when I select option1, it would give me the data from my "Sheet1('sheet1's name is RB) Column C" into my combo box.
Then if I select option2 Sheet2('Sheet2's name is WR) Column C would enter into the combobox.
I have code written that once I choose the item in the combo box, it then places the info into the active cell.
I already thought about making a master list with all the data from all the sheets, but I really would rather them be separate.
Thank you,
Michael