View Single Post
  #1   Report Post  
Nigel
 
Posts: n/a
Default UserForm and combo box to another sheet

Hi,
i need to create 2 things.
1. a userform to add new contact & client details to a hidden data sheet
2. a combo box in an excel sheet to use the information from the hidden sheet.
I have found a combobox and data on the same sheet thanks to Deborah
Dalgleish's site information which states that the data can br created on
another sheet. however, i cannot fint how to link the "listfillrange" to it.
The userform should appear with the press of a button and have the following:
contact name, Company, address, phone number, mobile number.
when appy is pressee, the info goes underneath the last inputted date in the
same range.( i have a code to automatically find the next mpty cell).

Can anyone help me with this?

Regards,

nigel