Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,670
Default How to retrieve value from specific cell value?

Does anyone have any suggestions on how to retrieve value from specific cell
value with specific worksheet?
I would like to create a if-statement within macro,
If specific cell within specific worksheet = 1 then
process following code
End If
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default How to retrieve value from specific cell value?

hi
If Sheets("sheet1").Range("A1") = 1 Then
MsgBox "run code"
Else
MsgBox "skip code"
End If

regards
FSt1

"Eric" wrote:

Does anyone have any suggestions on how to retrieve value from specific cell
value with specific worksheet?
I would like to create a if-statement within macro,
If specific cell within specific worksheet = 1 then
process following code
End If
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

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
retrieve specific info from different 'groups' firewaterjoe Excel Programming 0 March 30th 09 06:41 PM
How do I retrieve a specific record into excel from an external db Hope Excel Programming 0 May 16th 08 02:00 PM
Retrieve Numeric Label for Max Value by Specific Day & Month T. Valko Excel Worksheet Functions 4 February 20th 07 10:34 PM
Retrieve Numeric Label for Max Value by Specific Month Sam via OfficeKB.com Excel Worksheet Functions 8 February 20th 07 06:10 AM
Retrieve specific date from one row of one column that is changing lpdc Excel Worksheet Functions 2 June 14th 06 12:33 AM


All times are GMT +1. The time now is 11:59 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"