run different code upon the number assigned in textbox

[copythat]

Hi there,

I would like to have a code that inputs the data from textbox1 (in userform) to a certain range upon a number in textbox2 (in userform).

For example if I input "1" to textbox2, the data in textbox1 will be pasted in range AE3
if 2 --> AD3
if 3 --> AC3
.
.
.
if 30 --> B3

Please Login or Register  to view this content.

Thanks,

PS I want to do this otherwise I need to have 30 buttons to run each of them.

[copythat]

I have already got it and now it works.

Please Login or Register  to view this content.