VBA code snippet to enter numbers in a cell upon selection

[Karthik Thandapani]

Hi,

Can you please provide a code snippet to enter values (1 to 12) in a particular cell? The requirement is to change month according to the selection. There are next & back button to guide the user for changes.

Or simply enter January by default, click next to enter February, next to March and so on.

Any help?

Please see the attached file.

Regards,
Karthik

 

[Hui]

see attached

Note the the controls simply increment/decrement the cell E9
The cell E10 is now a date and is constructed using the Year and Months in the relevent cells

 

[Karthik Thandapani]

@Hui , looks like "increase month" macro keeps adding digit but not limited to 12. And also the other button is taking month digit to negative. Pls fix

 

[Hui]

see attached

Have a look at the code module and see how to limit the values

 

[Karthik Thandapani]

Thanks @Hui