User Profile
fredc2022
Brass Contributor
Joined 3 years ago
User Widgets
Recent Discussions
VBA Find (What:="") tied to dropdown list box
In the VBA Find(What:=), I want the What:=" " to get it's value from a drop down list box in sheet1. I have two worksheets, 1) sheet with three dropdown list boxes 2) sheet with unstructured data where the data from dropdown box wiil be found. These are the VBA codes I have. Thank you for any help ou can give. Cells.Find(What:="DALLAS COWBOYS", After:=ActiveCell, LookIn:= _ xlFormulas2, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _ xlNext, MatchCase:=False, SearchFormat:=False).Activate Cells.Find(What:="WEEK 3", After:=ActiveCell, LookIn:=xlFormulas2, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ActiveCell.Offset(0, -3).Select Cells.Find(What:="Cardinals Drives", After:=ActiveCell, LookIn:= _ xlFormulas2, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _ xlNext, MatchCase:=False, SearchFormat:=False).Activate 'Range(ActiveCell).Select ActiveCell.Offset(5, 0).Select Range(ActiveCell, ActiveCell.End(xlDown)).Select Selection.End(xlDown).SelectSolved14KViews1like46Comments
Groups
Recent Blog Articles
No content to show