passing variable from one sub to another

Philb1 · #2 03-17-2016, 04:18 AM

Hi

Try changing the code to the below & see if it works for you. I've extracted bits of your code & changed it
Cheers

Code:

'==========================
Private Sub Worksheet_BeforeDoubleClick _
  (ByVal Target As Range, _
    Cancel As Boolean)
    
Dim Position As String

  Position = Target.Address
  
      TempCombo_LostFocus Position
        
errHandler:
  Application.EnableEvents = True
  Exit Sub

End Sub
'=========================================
Private Sub TempCombo_LostFocus(ByVal Position As String)

MsgBox (Position)

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
userform help (having trouble passing info from form to macro)	cyraxote	Word VBA	16	09-08-2015 04:16 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM