Hello
What i need to do is this.
When we open the userform1, then i need in textbox1 the current date and in textbox2 the NEW order number, starting with letter L.
In my example as in column C of database sheet, there is not the order L1(exist only orders V1&v2), the order number that should appear in TextBox2 should be L1.
Can you help me on this?
Thanks in advance for any assistance!
Hi
Make column C on the data-sheet a named range call "OrderNumber", then right UserForm1, choose "View code" and paste this:
It takes a while to load so you might want to make the named range a little bit shorter.
Please Login or Register to view this content.
Best regards
Per Erik Midtr?d
Please Login or Register to view this content.
Hello
perimidt
Thank you. Your code does exactly what i need!
Mr Phillips
Thank you for your suggestion. A suggestion from an Excel Legend!I have read so many articles of you!
Unfortunately-as i believe- my bad English didn't let me to explain well what i need so your code doe not works for me. Sorry for that!
You can see my example to understand what i mean!
I didn't include the sheet name, so it worked only if Database was active. Easily fixed
A question for you. Where is Hania? Is that in Greece?Please Login or Register to view this content.
Last edited by Bob Phillips; 12-23-2013 at 04:35 AM.
Yes Mr Phillips.
Chania-Crete-Greece!!
And YES, now works great. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks