to change the value in text box when click on spin button

[ajaar]

Dear Friends,

I have attached file created Text box in User form, when I select unique number all other text box get automatically updated, I wanted increase and decrease Unique number from the data available in C2:C10000 when I click on the spin button next to that, I struck here, could any one please help me.

Regards
Ajaar

 

[Somendra Misra]

Hi Ajaar,

See the file. I had changed your named formula unique, go through it and change others also like this. I had also changed some property of Spin button like min , max and value. Go through them also. Plus a code for spin button change is added.

Regards,

 

[ajaar]

Hi Ajaar,

See the file. I had changed your named formula unique, go through it and change others also like this. I had also changed some property of Spin button like min , max and value. Go through them also. Plus a code for spin button change is added.

Regards,

Dear Somendra,

Great help.. thank you somuch for your help.

Regards

Ajaar