Forum Discussion
Solved
how to use FindControl to execute the VBE Find... command
i am trying to find the ID for the VB Editors Find... command. when i use this string, i get the Find command from excel (for searching cells). i want to execute the other Find (from VBA). how can i do that?
Application.CommandBars("Edit").Controls("Find...").Execute
i have tried to use FindControls but it doesn't return the ID from Application.VBE.Commandbars.
and below does the same thing as above
Application.CommandBars.FindControl(id:=1849).Execute
How can i make this work so that i get the right Find command?
- Application.VBE.CommandBars.FindControl(id:=141).Execute is the solution. had it in another forum, just found it.
1 Reply
- Application.VBE.CommandBars.FindControl(id:=141).Execute is the solution. had it in another forum, just found it.