Hello all,
I have a large database of food items within an excel workbook that counts calories. I am looking to incorporate a search procedure, much like Excel already has under the Edit and Find (Ctrl+F) function, but using VBA, to allow users to easily look up their food items. I have tried recording a macro, but it turns up blank.
Is there a command to bring up the Find Dialog box? I don't want to modify anything in the database, simply search it, so any ideas are welcome.
Thanks in advance,
Tom.
I have a large database of food items within an excel workbook that counts calories. I am looking to incorporate a search procedure, much like Excel already has under the Edit and Find (Ctrl+F) function, but using VBA, to allow users to easily look up their food items. I have tried recording a macro, but it turns up blank.
Is there a command to bring up the Find Dialog box? I don't want to modify anything in the database, simply search it, so any ideas are welcome.
Thanks in advance,
Tom.