Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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
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
Need to populate data from different sheet. Joe Spindola Excel Discussion (Misc queries) 1 May 11th 10 04:04 AM
Populate Data Into Different Areas igbert Excel Discussion (Misc queries) 2 July 16th 09 04:17 AM
Pulling data from other wb based on data to populate dropdown list Suzann Excel Discussion (Misc queries) 0 April 23rd 09 04:29 PM
populate a list box with different data [email protected] Excel Programming 9 May 12th 05 09:17 PM
Take data from one worksheet to populate another Josh[_4_] Excel Programming 2 July 25th 03 06:41 PM


All times are GMT +1. The time now is 10:50 PM.

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

About Us

"It's about Microsoft Excel"