PDA

View Full Version : Can a Userform generate a record #?



klutz
11-14-2011, 08:21 PM
Hi,

I'm currently working on a Userform for salesman call in which users will use to enter (partial) data. That data is automatically copied into a worksheet with partial information. I mean partial because some of the informationm wont be entered until an outcome of a sales call is known.

My question is; Can Userforms generate a record number (of course with VBA code)?

DO I need another Userform to do the search and then complete the missing fields? There should only be 1 filled to be filled in, that would be the outcome of the call.

Can anybody help me.:friends:

I have atatched the file of what I have...thus far

P.S. The Userform I have I found and revised it to meet some of my needs. So thanks to the person who was kind enough to post and share...