Macro help

J

J-man

I need to create a macro to which popos up the find function. this
cannot be done via recording, and i do not know of the command in which
to use in Visual Basic. Could anybody please let me know of the
command, or any way in which this can be possible. Thanks a lot guys.
Any feedback's be much appreciated. J
 
J

J-man

please guys. anyone? what it is used for, is in a customer bank for a
business. i will have a list of customers, and if a customer wants
their details deleted, i need to obviously delete the details. But seen
as there will be so many customer records in the list, i need to use
the find function in order to find the specific record. I would like to
use a macro to pop the find function up, if it is possible, for time
efficiency. Any methods/solutions to this, please provide. thanks a
lot guys. J
 
P

Paul Moles

Don't know of a macro, though there are others far
cleverer and more knowledgeable than I, myself I would use
control F as this is the shortcut key combination for the
find fnction. Unless yours has been reallocatied.

Paul Moles
 
J

J-man

Awesome :D :D :D, that worked. Thanks a lot man, it's really helpful.
Sorry to be a nuisance, but i have one more question, similar to this
one i previously asked. I need the same thing to happen, but instead, i
want it to pop up the save as function, where preferably, i would like
to just be able to save the active worksheet. If this is possible, and
you can provide the command, htat would be really cool. Thanks, all,
for your help already. It's really helpful. J
 
J

J-man

right, i figured out how to pop up the save as function, but the onl
thing i want to ask now: is there any way of just saving the activ
worksheet as apposed to the whole document. Any feedback'd be awesome
Cheers guys.
 
V

Vasant Nanavati

Not really. You could copy the worksheet to a new workbook and then save it,
but that's about it. Or you could delete all the other sheets and save the
workbook with the sole remaining sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
How do I set focus (and select text) on a text box on a modeless userform? 0
watch macro while it is recording 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9
How to modify and updte specific styles for specific paragraphs across the document 0
Global Template Network and saving auto texts & macros 2
merging duplicate donors and donation amounts from different years 8
saveas macro help 1

Top