Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
hi,
how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub "peyman" wrote: hi, how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
thanks Mike.that's great.I have one more question.what's the difference
between "worksheet code module" and "standard code module"?what codes are usually posted in "standard module"? thank you again "Mike" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub "peyman" wrote: hi, how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
Worksheet module is the code module behind a worksheet, it is a specific
type of class module. Typically, it is where you add code specific to that worksheet, such as the worksheet event code that you were given. A standard code module is where you add procedures that are more generic, or need to be accessed from multiple places. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "peyman" wrote in message ... thanks Mike.that's great.I have one more question.what's the difference between "worksheet code module" and "standard code module"?what codes are usually posted in "standard module"? thank you again "Mike" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub "peyman" wrote: hi, how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
thank you Bob, but can you make an example for standard module code?
"Bob Phillips" wrote: Worksheet module is the code module behind a worksheet, it is a specific type of class module. Typically, it is where you add code specific to that worksheet, such as the worksheet event code that you were given. A standard code module is where you add procedures that are more generic, or need to be accessed from multiple places. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "peyman" wrote in message ... thanks Mike.that's great.I have one more question.what's the difference between "worksheet code module" and "standard code module"?what codes are usually posted in "standard module"? thank you again "Mike" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub "peyman" wrote: hi, how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
Put this into a standard module
Sub exampleforstandardmodulecode() If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub Put this into a Thisworkbook module Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Run "exampleforstandardmodulecode" End Sub Now for every sheet in workbook when D11 is selected your msgbox will pop up "peyman" wrote: thank you Bob, but can you make an example for standard module code? "Bob Phillips" wrote: Worksheet module is the code module behind a worksheet, it is a specific type of class module. Typically, it is where you add code specific to that worksheet, such as the worksheet event code that you were given. A standard code module is where you add procedures that are more generic, or need to be accessed from multiple places. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "peyman" wrote in message ... thanks Mike.that's great.I have one more question.what's the difference between "worksheet code module" and "standard code module"?what codes are usually posted in "standard module"? thank you again "Mike" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub "peyman" wrote: hi, how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox in VBA
than you MIke.got it.
"Mike" wrote: Put this into a standard module Sub exampleforstandardmodulecode() If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub Put this into a Thisworkbook module Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Run "exampleforstandardmodulecode" End Sub Now for every sheet in workbook when D11 is selected your msgbox will pop up "peyman" wrote: thank you Bob, but can you make an example for standard module code? "Bob Phillips" wrote: Worksheet module is the code module behind a worksheet, it is a specific type of class module. Typically, it is where you add code specific to that worksheet, such as the worksheet event code that you were given. A standard code module is where you add procedures that are more generic, or need to be accessed from multiple places. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "peyman" wrote in message ... thanks Mike.that's great.I have one more question.what's the difference between "worksheet code module" and "standard code module"?what codes are usually posted in "standard module"? thank you again "Mike" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Address < Range("D11").Address Then Exit Sub MsgBox "Cell D11 is selected" End Sub "peyman" wrote: hi, how can I write a code by which when only a cell like D11, is selected, a msgbox pops up? thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msgbox | Excel Discussion (Misc queries) | |||
MsgBox | Excel Discussion (Misc queries) | |||
MsgBox | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) |