Using 'Target' as a public variable

**tanktata** · 06-23-2014, 11:23 AM

Hi,

I have a worksheet and in column D i have several amounts, all numbers. I'm using the on double click worksheet event to trigger a macro when one of these cells is the 'Target'. I want the value of that cell to be available as public variable, so I can use it in modules called by the on double click event.

I've tried declaring it as Public in a normal module but I couldn't get it work.

thanks in advance for any help.

**patel45** · 06-23-2014, 11:36 AM

Public Target1 as range

Private Sub Worksheet_Change(ByVal Target As Range)
set Target1 =Target
...............
End Sub

**Norie** · 06-23-2014, 11:40 AM

Why not pass Target as an argument to the other subs?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Call AnotherSub(Target)
End Sub

Sub AnotherSub(Target As Range)

End Sub

**tanktata** · 06-24-2014, 01:12 PM

Went with nories solution, didn't now that was possible, still a noob!! Thanks for the help.

Using 'Target' as a public variable

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using 'Target' as a public variable

Re: Using 'Target' as a public variable

Re: Using 'Target' as a public variable

Re: Using 'Target' as a public variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro can't see a public variable

Define a public variable

Public Variable value

Public Variable

[SOLVED] Public variable

Bookmarks

Bookmarks

Posting Permissions