I created a multipage userform in excel VBA.
userform Page 1 for info data entry
excel sheet sample below
A B C D
Name Age case# file#
1 Mr. x 27 2345 5677
2 Ms. Y 49 2356 5678
userform Page 2 for number of hours worked entry:
Name :Combobox stating row source A1:D2
Age : label 1
Case#: label2
File#: label3
Hours : will type in>
My question is , if I select a name in combobox in userform page 2 , how it is possible to display corresponding data in label 1 , label 2 and label 2 automatically.
Please help.
userform Page 1 for info data entry
excel sheet sample below
A B C D
Name Age case# file#
1 Mr. x 27 2345 5677
2 Ms. Y 49 2356 5678
userform Page 2 for number of hours worked entry:
Name :Combobox stating row source A1:D2
Age : label 1
Case#: label2
File#: label3
Hours : will type in>
My question is , if I select a name in combobox in userform page 2 , how it is possible to display corresponding data in label 1 , label 2 and label 2 automatically.
Please help.