View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
deen deen is offline
external usenet poster
 
Posts: 45
Default 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