Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate data
Hi All. I'm trying t0 enter specific numerical data in to one table on Sheet3. I then want that data to populate into specific cells in Sheet2. Once the data has been populated, any future attempts to populate would give a message: "This cell(s) have already been populated. Do you wish to continue: Yes NO Thanks for any help. EP -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=535881 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate data
Test the cell before you do the input - if you are putting data into
cell A3 for example if len(range("A3").value)0 then n=msgbox("Do you wish to continue?",vbyesno) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to populate data from different sheet. | Excel Discussion (Misc queries) | |||
Populate Data Into Different Areas | Excel Discussion (Misc queries) | |||
Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
populate a list box with different data | Excel Programming | |||
Take data from one worksheet to populate another | Excel Programming |