Code for auto generate serial number

[G.Manikandan]

Hello great Ninjas,
Greetings. I have an excel sheet, in which Column B will be entered with data. I need the column A to have serial numbers, once the Coulmn B is entered. Can you please help me with the VBA Codes?

My sincere thanks for your help.

Regards,
G.Manikandan

 

[Lakshmi Narain]

Hello great Ninjas,
Greetings. I have an excel sheet, in which Column B will be entered with data. I need the column A to have serial numbers, once the Coulmn B is entered. Can you please help me with the VBA Codes?

My sincere thanks for your help.

Regards,
G.Manikandan

Hi Mani,
We can do with a simple formula. Is VBA required mandate?

 

[Khalid NGO]

Hi G.Manikandan,

You can use simple formula approach do to this:
Suppose your data in B2 and you want serial # in A2:

=IF(B2="Your_condition_"=TRUE,ROW()-1,"")
Copy down...

"Your_condition_" can be ISBLANK, ISNUMBER, ISTEXT, etc etc.

It will ease users to help better if you upload your sample file.

Regards,

 

[G.Manikandan]

Hello Lakshmi Narain, Khalid NGO,

Thanks for your feedback. How ever, I use forms to enter the data in the column B:F. That is why, I need a VBA code, which I will insert rather a formulae. Still, if you recommend to use formulae for this function in this condition, I will use it. (I am not sure that, in a work sheet having vba code, having formula for few applications are good, or to have all put into VBA codes)

Thanks
Mani

 

[Khalid NGO]

Hello Lakshmi Narain, Khalid NGO,

Thanks for your feedback. How ever, I use forms to enter the data in the column B:F. That is why, I need a VBA code, which I will insert rather a formulae. Still, if you recommend to use formulae for this function in this condition, I will use it.

Mani,
Can you share your file?
If so, there are number of experienced members here will help you in real time.
If not, at least i am not be able to understand your actual requirement.

(I am not sure that, in a work sheet having vba code, having formula for few applications are good, or to have all put into VBA codes)

Thanks
Mani

Chandoo.org have lots of Great Dashboards with VBA+Dozens of Formulas.

Regards,

 

[G.Manikandan]

Hello Great Ninja, Good day. Here is the file attached. Can you please help it out? (The combo box is not working, however, I will be able to fix it) Therefore, you need not to look into the combo box problem.

Thanks and regards,
G.Manikandan

 

[Nebu]

Hi:

Please find the attached. Hope this is what you are looking for...