VBasic Userform in excel, need it to place a number by each row

163 Views | 0 Replies | Last: 13 yr ago by mason12
yuppie24
How long do you want to ignore this user?
I have a macro I made for work whereby a userform is brought up, you enter in four categories of data, and it populates the excel sheet for 4 columns. I would like to add a numbering function to this so that it will count the number of entries as I go along. Anybody know anything about this?
mason12
How long do you want to ignore this user?
AG
You need to write code to where everytime you hit new form it adds a number to the count column. You may need to go in and add up all previous entries. You could also write a search function that counts for you. It's been 2 years since my VB class sorry if i'm wrong.
Refresh
Page 1 of 1
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.