Withusing of input box data store in given cell
Hi Friends,
In sheet1 i need to given input data with using of input box,
EG: In sheet1 A1:A7, once open the excel input box have prompt as data
like below,
Data1 enter the value ____________
Data2 enter the value ____________
Data3 enter the value ____________
Data4 enter the value ____________
Once i enter the data click "OK" automatically data store in a1 to a4
based on input and rest of the cell will be blank( a5 to a7)
Thanks & Regards,
Deen
|