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
Bookmarks