[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

UserForm Invoked upon Selecting a Value in a List

Hello Experts - I am looking for a solution that will  allow me to click on a cell with a list of values and then if a specific values is selected a UserForm would get launched with further options.
The trick does not appears to be working with tracking ActiveCell, as it does not detect options in the list. I attached a file showing what I am after.

Cheers, V
UserForm-invoked-upon-choosing-a.xls
0
NewToVBA
Asked:
NewToVBA
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Right-click on the sheet name
select "View code"
paste the following code in the VBA window
Close the VBA window
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim x As Long
    
x = Sheets("Sheet1").Range("C" & Rows.Count).End(xlUp).Row
If Trim(Cells(1, ActiveCell.Column)) = "Selection" And ActiveCell.Row <= x Then launch
End Sub

Open in new window

0
 
NewToVBAAuthor Commented:
Excellent, this is what I was looking for.
Thank you Ssagibh!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now