Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find button on worksheet
I was given a suggestion to use
Application.Dialogs(xlDialogFormulaFind).Show in place of the Sendkeys method from my original post below that I couldn't get to work. However, the Dialogs.Show method opens the Find form read-only and will not work. The reason I am trying to place this button in the spreadsheet is because it will be used on a pocket PC that doesn't have the ability to add the icon to the toolbar. Besides, it should be possible to do... My original post was: I have been trying to use the Sendkeys command to open the Find form. The short cut to Find is Ctrl+F; however I cannot get it to work. I tried Sendkeys to bring up Spellcheck and it worked fine. What am I doing wrong? Here is my code: Private Sub CommandButton1_Click() Application.SendKeys "{^F}" End Sub TIA, Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find&press button | New Users to Excel | |||
find&select button,help please? | Charts and Charting in Excel | |||
print different worksheet by pressing visible button on worksheet | Excel Worksheet Functions | |||
Find button in excel worksheet | Excel Programming | |||
Find button in excel worksheet | Excel Programming |