View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Burke Burke is offline
external usenet poster
 
Posts: 2
Default creating a combo box that shows multiple entries.

I have an address list in one worksheet. I have a form in another worksheet
where I want to place a combo box that will allow me to select the person's
name and then fill in all the other columns with their address, phone number,
city, state, etc, on the form. Another vaariation of this is where I would
like to select the name of a person to go in that row and only have select
columns of information showing across the form (ex. I need name and address
but not birthday or spouse name). Does anyone know how do perform this
operation? I realize I can create this in Access, but my work computer does
not have MS Access installed.
Many thanks,
--
Russell Burke