LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation: Store cell address instead of value in the cell? WillW Excel Discussion (Misc queries) 1 January 31st 07 02:22 AM
Store cell data in a variable snowing[_2_] Excel Programming 1 May 28th 06 07:04 PM
How to store custom data into Excel cell [email protected] Excel Programming 0 March 7th 06 12:27 PM
Unsing names to store input from Userforms Pavlos Excel Programming 4 September 10th 04 12:51 PM
Store Hidden Data in the Cell Yishi Excel Programming 2 December 12th 03 11:57 AM


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"