Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advancing A Number With The Push A Button
Greeting,
I tried this in the misc group, but I think that was the wrong group, so here goes, again.... I have an invoice that uses a button to advance the invoice number by 1. When I wrote it the numbers were just numbers, but since then a letter has been added to the front of the number (was 17445 now D-017445). My advancing code no longer works and I don't know why! Here is the code: Private Sub GetNextInv_Click() Range("InvNoLast").Value = Range("InvNoLast").Value + 1 End Sub Anyone have an idea on how to fix it? Any help would be most appreciated. TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Push button and input box? | Excel Discussion (Misc queries) | |||
Time with the push of one button | New Users to Excel | |||
push button paste special | Excel Discussion (Misc queries) | |||
Which button did I push | Excel Programming | |||
Searching in a row with push on a button | Excel Programming |