Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using an if then statement call a caption box to a cell
In my excel project, I have a cell that performs a sum function. a associated goal is tied to that cell and consequently the results... want to develop an if then statement that upon reaching the goal, caption, lable, or text box (msgbox) will appear and give a message t the user...how is this possible? tks ahead of time ratt ou -- rat ----------------------------------------------------------------------- ratt's Profile: http://www.excelforum.com/member.php...fo&userid=2431 View this thread: http://www.excelforum.com/showthread.php?threadid=37957 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using an if then statement call a caption box to a cell
do you use a control to put it in or do you put it directly tin to th code...do you dim ianything in the code or do you simply put it in th cell like you would a formula? tk -- rat ----------------------------------------------------------------------- ratt's Profile: http://www.excelforum.com/member.php...fo&userid=2431 View this thread: http://www.excelforum.com/showthread.php?threadid=37957 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using an if then statement call a caption box to a cell
Hi, Since you posted this in the programming section, and since you had not given any more details.... Assuming that you enter your input in cells A1 and A2, And cell B2 is the one which you want to check, you could have enter the following code in the module of the concerned sheet. Right click on the tab which holds the sheet name, click view code, and enter the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Or Target.Address = "$A$2" Then If Range("B2") = 100 Then MsgBox ("Goal value reached") End If End If End Sub Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=379571 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Caption attribute at Cell in Excel XML | Excel Discussion (Misc queries) | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
Textbox.caption to cell if empty, how? | Excel Programming | |||
Can you call a macro as in an IF statement | Excel Programming |