chronotonFlux
New Member
- Joined
- Dec 18, 2017
- Messages
- 8
I have a project that has a dropdown list for user selection
based on the item selected, I want to be able to write user data to a different tab of the destination workbook.
For example if user selects "Banana" from the list
I want the submit button to go to "Workbook2"
then set Worksheet to user selected "Banana" and write the data.
I thought this would be done by getting the cell value of the user selection, specifying it as a variable and then referencing that variable, but I'm missing something as:
wb1.Sheets(variable)
doesn't do anything and triggers debug mode to freak out
based on the item selected, I want to be able to write user data to a different tab of the destination workbook.
For example if user selects "Banana" from the list
I want the submit button to go to "Workbook2"
then set Worksheet to user selected "Banana" and write the data.
I thought this would be done by getting the cell value of the user selection, specifying it as a variable and then referencing that variable, but I'm missing something as:
wb1.Sheets(variable)
doesn't do anything and triggers debug mode to freak out
