i've got a sample database (attached) with a userform for inputting of data. What i want it to do is automatically generate the next number and add it to textbox "our ref" on the userform. the number is in Col C. This is the code i've tried using the code highlighted in red which doesnt work..... can you point me in the right direction ?
i've attached said file...
Please Login or Register to view this content.
Last edited by royUK; 04-10-2008 at 08:53 AM.
Hi
Try
Please Login or Register to view this content.
rylo
that gives me a number but it doesnt give me the next consecutive number
You don't need all those Loops nor Selections. Change the initialize code to
Please don't use colours and large font in your code as above it is not helping us read it!Please Login or Register to view this content.
A TextBox does not have an additem method.
Search the Forum for some examples of userforms or look at the databaseform example here
http://www.excel-it.com/vba_examples.htm
Last edited by royUK; 04-10-2008 at 06:36 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I think this is what you are trying to do
Just my opinion but I would definitely lose the greenn background of the userformPlease Login or Register to view this content.
This is only giving me 1 where as the last number in col c is 8 so i would want it to give me the next number which would be 9 and the next time a sample is entered it would be 10 and so on.
point taken on the green........ now you mention it it does look in your face.
Make sure that your cells are formatted as number.
they were formated as general but changed them to number but it's still giving me the number as 1
Not in the example workbook that I downloaded, I get 9
Last edited by royUK; 04-10-2008 at 07:55 AM.
i'm lost i've tried changine the formatting the type in my own sample i'm lost.
this is the code for the whole userform that i'm using. i cut and paste your code over the old code for textbox3. which is at the very bottom.
Please Login or Register to view this content.
i download the version you edited and that works but when i copy the same code onto my version it doesnt work ? The actual file is 500kb.
Your original numbers in Column C do not appear to be recognised as numbers, I had to type them in again.
bingo !Obvious really i suppose. yet again this forum saves the day. thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks