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




--
ameliaeng