Need some help/advice
I have a spreadsheet with 40 rows
Each row contains the following
Column A = Last Name
Column B = First Name
Column C = Dollar Amount
Column D = Date
Column E = Comments (50 String Length)
I have a User Form with the following
Combobox1 = Column A and Column B
Textbox1 = Column A
Textbox2 = Column B
Textbox3 = Column C
Textbox4 = Column D
Textbox5 = Column E
Controlbutton1 = Update
Controlbutton2 = Cancel
I want to be able to load the combobox1 with column a/b rows 1 to 40
When a user scrolls the combobox1 I want the corresponding textboxes from
the spreadsheet to be filled in. (if the user scrolls the second name row
2, then textbox1 = row 2 col a, textbox1 = row 2 col b, etc…
If a user changes the data in the userform I want to update the
spreadsheet for that record.
Does this make any sense.
I need to be shown how this can be done. I'm not even sure it can be
done.
Bookmarks