Advice to call a code

[ipbr21054]

Hi,

I have a msgbox where No closes it but i would like when Yes is clicked it will Call say the below to run it

Private Sub DHLBUTTON_Click()
ActiveWorkbook.FollowHyperlink Address:="http://www.dhl.co.uk/en/express/tracking.html", NewWindow:=True
End Sub

can you advise the correct way to wright it please

 

[ipbr21054]

Please see post 8

 

[Yard]

If its easier for you.
The customers name is also selected in column A
Then the userform DATABASE opens.

So remember the selection in Column A & use that to select from the comboBox ?

Haven't used UserForms in a while, so I'm a bit sketchy, but in principle you just need to declare another variable to "remember" the selected value from the ListBox, and then make the value of the ComboBox equal to that value stored in that variable

 

[ipbr21054]

ok thanks.

Ive started to try with this.

Private Sub ListBox1_Click()
  Dim answer As Integer

  Range("A" & ListBox1.List(ListBox1.ListIndex, 1)).Select
  answer = MsgBox("OPEN DATABASE ?", vbYesNo + vbCritical, "OPEN DATABASE MESSAGE")
   If answer = vbYes Then
   Unload DatabaseNameSearch
   If ListBox1.Value = True Then
   Database.Show
   ComboBox1.Value = ListBox1.Value.Select
  
    Else
    Unload DatabaseNameSearch

If anybody could advise please.
    End If
End Sub

 

[ipbr21054]

I havent progressed any more since my last post.
I am able to select a customer from the listbox which then closes leaving that customer selected on my worksheet.
The code i have which is a double click code does what i require BUT the code cant double click so another alternative to run the double click code needs to be addressed.

Then im done as its completed.

 

[Yard]

I'm really sorry, I just can't understand what you're saying. I don't think you're asking anything about a userform or listbox any more, I think you want something to happen when you double click a cell on a worksheet. Can you explain in another way so I can help?

 

[ipbr21054]

My goal is to open the customer that was selected in the ListBox1 on the userform called Database.
That is my goal.

What i am saying is if i double click the name in column A then the userform opens & that name i double clicked is now in front of me.
This is an example of whats happens.

So,
The userform opens.
I partial type a name is the search field.
All customers that partial match are now shown in the listbox
I then select the correct customer.
The userform closes & that customer is now currently selected in column A

THIS IS WHERE IT STOPS.

So what im saying is we need to have the customer in this active cell open up the userform DATABASE & there record then be shown.

How about that ?