hi,

i wanted to write a macro that finds a word said by a user. is there any code to write it? in the sense, the code reads in the word by user instead of hardcoding it or typing it out?

for e.g.i want to find a word like "hello" in the spreadsheet. i know ctrl+ F is the [find] but i want to find through speech recognition. in the sense, when the user say something.. the macro would automatically takes in the spoken word and find the word he said.

i've tried recording a macro by just pressing ctrl+f. in the sense, just plainly record a macro ctrl+f stop recording(without saying anything that i want to find). and when i try to play back, it doesnt pop out the [find]. in fact, there isnt any movement. but if i record the macro with a word for it to find, meaning record a macor ctrl+f 'hello' being input in the textbox find next stop recording. and i play back, it would search for 'hello'.. but what i want was when the user say [find], the macro would to just pop out the [find] window and let the user say the word itself and when the user says[find next] it will find the word.



and also,
is there any recommended links so that i could reference up on VBA in Excel Macros?


thanks