Menu

Excel macro activation.

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Kate Smith Kate Smith is offline

Kate Smith is offline

external usenet poster

Posts: 2

Default

Excel macro activation.

Hi Christine,

I tested your macro. It works. Thanks.

Kate

(Christine Flott) wrote in message . com...
Kate,

How exciting. I'm pretty new with VBA but I just created a macro that
does what you explain. You'll want to create a "Worksheet_Change"
Private Sub. As an overview, Worksheet_change procedures run whenever
there is a change in the worksheet in general. However, you can tell
it to look at a specific range. See below. This is not tested but
pulled from the macro I just wrote (which works).

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim VRange As Range, Cell As Range
Dim ValidateCode As Variant
Set VRange = Range("your_cell_here")
For Each Cell In Target
If Union(Cell, VRange).Address = VRange.Address Then
ValidateCode = EntryIsValid(Cell)
If ValidateCode = True Then
**code here**
Exit Sub
End If
End If
Next Cell
End Sub

Private Function EntryIsValid(Cell) As Variant
If Cell = "B" Then
**code here**
Else
exit sub
End If
End Function

Hope this makes some sense. Good luck!
Christine

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
List activation on Excel	bfbankpatrick	Excel Worksheet Functions	1	February 4th 09 05:44 PM
ctrl-click hyperlink activation in excel	MPH55a	Excel Discussion (Misc queries)	1	September 23rd 05 07:24 PM
Excel macro activation.	Pete McCosh[_3_]	Excel Programming	0	July 29th 03 04:59 PM
Excel macro activation.	Dick Kusleika	Excel Programming	0	July 29th 03 04:47 PM
Excel macro activation.	Dave Ramage[_2_]	Excel Programming	0	July 29th 03 04:47 PM

All times are GMT +1. The time now is 03:59 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement