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...
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...