increasing number by 1

[rharri1972]

Hello! I have a need for an increasing number, incrementally, by 1 each time the userform is activated/initialized.
This will be an increasing number on an order form to become the identifying order number.

thanks for ANY HELP!

 

[davesexcel]

Where is this number and why can you not add 1 to it?

 

[JEC]

Store the number somewhere in your sheet, which is increasing everytime you submit a form.
You can easily load that number into your form.

Another method is to find the last row of the table, where you put the data.

 

[rharri1972]

Where is this number and why can you not add 1 to it?

sorry Dave. I am attempting to learn vba by trial and error, im sure like everyone else did. My thought is to have the number increase by 1 each time the userform opens, however, I was just thinking that the userform itself has no idea the number even exists so i have just now created a worksheet, tabbed "ID's" in column "A" I will put my beginning number in "A2". Then, hopefully with your help, I will learn how to code for TEXTBOX12 to read the ID # in the last filled row of column "A", add 1 to it and that will be the value of TEXTBOX 12. And of course, I would want to record this incremented number in the next available row in Column "A" on the "ID's" worksheet. I hope i did a better job of explaining this time and thanks for any help you are willing to provide.

 

[rharri1972]

Store the number somewhere in your sheet, which is increasing everytime you submit a form.
You can easily load that number into your form.

Another method is to find the last row of the table, where you put the data.

Thank you JEC. you've helped a lot!

 

[rharri1972]

Thank you JEC. you've helped a lot!

Am wondering if you would mind me asking about a combobox1 I have on userform3.
Here is my code:
Me.ComboBox1.RowSource = "Customers Select!A2:G" & Range("G" & Rows.Count).End(xlUp).Row

it returns "could not set the resource property. Invalid propery value"

I got this from a video in google and although it worked for her...it does not for me.

I am attempting to populate my Combobox1 from worksheet "Customers Select". Range "A2:G (last row used)

I will use this list to select a certain customer to fill other text boxes. The information will be a customer ID, Customer Name, and their address.

I have looked all over google and can't find anything to help. Could be I just don't know how "to ask".

Any help?