Generate combination of numbers

[KKR1975]

Hi

Please help me to create VBA code on the below





Column CC and Category is user input, based on the User input the result required on next column

First 3 Digit number and Next 3 digit number in result should be updated based on user input on message box
USER TYPE
APPLE then 333 300
Orange then 433 400
Papaya then 383 700

Next 4 Digit number is from above user input in column B, if its blank then four zero '0000' to be considered
Next 5 Digit number is from above user input in column C, if its blank then five zero"00000' to be considered
Remaining all is default numbers (.0000.00000.000.000.000.000)


Here column B and C is for example, it may be in Column H & I or J&K
So by selection of CC and Category Numbers, the VBA code has to be executed for results

Step1 User will select the CC & Category Range ( in Example its column B and C)
Step2 Message box input required (To type "Apple", "Orange" and "papaya") to update first and next 3 digit numbers in Result columns
Step3 Next four digit number to be updated based on the user selection on Step1, if its blank the "0000" to be updated
Step4 Next five digit number to be updated based on the user selection on Step1, if its blank the "00000" to be updated
Step5 default number as ".0000.00000.000.000.000.000" to be updated

[Bernie Deitrick]

Select the two columns of cells and run this macro:

Please Login or Register  to view this content.

[KKR1975]

Hi Bernie Deitrick

Thank you so much for your help.

The code is working perfectly as expected.

Only one issue, the message box is asking to type input for each rows, instead its required only one time to select 1, 2 or 3
Ex. if user selected 1 entire selected rows updated accordingly.


Please help me to modify

[Bernie Deitrick]

Please Login or Register  to view this content.

[KKR1975]

Hi Bernie Deitrick

Excellent. code is working exactly what i want. thank you so much for your help
T