rhino4eva
Active Member
- Joined
- Apr 1, 2009
- Messages
- 262
- Office Version
- 2010
- Platform
- Windows
I have a 2 sheet workbook
sheet1 has 2 columns with the labels doctors and email in the top row
each doctor has one email
sheet 2 is a sort of a pre-arranged stationary that I need to add the doctors name and email to before they print out
I have been able to create a userform with 2 comboboxes for name and email which fills the selected name and email into the correct cells on the second sheet
however I would like to drop the second combobox on the userform and somehow link the name chosen in the userform to the correct email
would be grateful for assistance please
sheet1 has 2 columns with the labels doctors and email in the top row
each doctor has one email
sheet 2 is a sort of a pre-arranged stationary that I need to add the doctors name and email to before they print out
I have been able to create a userform with 2 comboboxes for name and email which fills the selected name and email into the correct cells on the second sheet
however I would like to drop the second combobox on the userform and somehow link the name chosen in the userform to the correct email
would be grateful for assistance please