Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Cell - Move to UserForm thom hoyle Excel Worksheet Functions 0 April 28th 05 12:23 AM
VBA Form Combo Box question. WTG Excel Discussion (Misc queries) 3 February 26th 05 04:28 PM
combo box formatting scrabtree23 Excel Discussion (Misc queries) 1 December 4th 04 05:07 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"