After the listbox gets chosen, how to populate another form

  • Thread starter Thread starter James
  • Start date Start date
J

James

I work for a very large company. We have multiple offices
in many states. I need to create a series of userforms so
the user can update employee information in each office. I
have a listbox with a list of 50 states. I have the code
to get this listbox populated and for the user to choose
the state. What I need to do now is to have another
worksheet queried and have a list of offices in that
particular state displayed. After I get this working, I'll
be back to ask how to get the information back from the
user and be populated into the original spreadsheet.

For example let's say I have an employee in Dallas Texas
who gets a new phone number. I want the user to be able to
go into the first form and choose Texas. (S)he will be
presented with another form that shows all of the offices
in Texas. The user will choose Dallas, then another form
will be displayed with a list of all employees in the
Dallas office. The user can then choose the employee and
be shown the employees name, employee number, etc. The
user should be able to click on the phone number, update
it and hit a button to have this correct information
written back to the original spreadsheet. I guess this is
called a drilldown application.
 
Hi Jim, thanks for the link. That looks like I would have
to redefine the entire workbook ( I have 7 shhets with
over140 rows per sheet. Can this be done via userforms (I
mention forms because I've used them in Word and they look
very professional)?
 
Back
Top