Auto-generate numbers in sequence/random

[Sameer.k21]

Greetings for the day !!!

I am trying a command button to auto generate numbers in sequence or may be random numbers on a click which should be in the "Combo-Box" next to it.

Is this do able? Please advice.

Regards,
Sameer

 

[Marc L]

Hi !

Yes but you could do the same by formula w/o any code !

​

 

[Sameer.k21]

Well, this combo box acts as a search box too. For the existing number in the list this auto populates the fields in the userform. So if its a new case, on a click the command button should generate new number and display that in combo box.

 

[Marc L]

See Rnd VBA function and its sample to generate a number …


​

 

[Sameer.k21]

Thank you, Marc. And what if I need numbers in sequence?

 

[Marc L]

Call function for each field when needed …


​