I'm looking for a place where I can find VB code of macro examples.
Something along the lines of when you click the macro button, a file open box
pops up and prompts the user to open a file. From there, the macro uses Find
(ctrl+f) to find a few cells and then manipulates them. Any suggestions on
where I can find VB code examples? If the macro doesn't use Find, it's okay
but I would like to use the file open feature. Thanks.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chris" wrote in message
...
I'm looking for a place where I can find VB code of macro examples.
Something along the lines of when you click the macro button, a file open
box
pops up and prompts the user to open a file. From there, the macro uses
Find
(ctrl+f) to find a few cells and then manipulates them. Any suggestions
on
where I can find VB code examples? If the macro doesn't use Find, it's
okay
but I would like to use the file open feature. Thanks.

Try

Application.GetOpenFilename

for the file open dialog

Can you elaborate a little more on what you need the FIND to do.

Usually, a google search using

Excel Find function VBA

would yield plenty of examples
--
Kind Regards,
Will Riley


"Chris" wrote:

I'm looking for a place where I can find VB code of macro examples.
Something along the lines of when you click the macro button, a file open box
pops up and prompts the user to open a file. From there, the macro uses Find
(ctrl+f) to find a few cells and then manipulates them. Any suggestions on
where I can find VB code examples? If the macro doesn't use Find, it's okay
but I would like to use the file open feature. Thanks.

As far as the Find function is concerned it may be a lot more complicated
than I actually can do. If Bob recalls, I wrote an hour response to what I
actually needed to do with the Find function about 2-3 weeks ago but I didn't
get a response (probably because I wrote so much). Anyway, I would like the
Find function to find cells depending on key strokes and NOT absolute
position. For example, If I use ctrl+f to find the word "Trials" and then use
my keypad to go 2 cells down and 8 cells to the right I would like to put a
formula in this cell. So If I made a macro and opened up a new file with
different data It would Find "Trials" go 2 cells down and 8 cells over and
put a formula in this destination. However, when the macro runs and uses
Find, it arrives at lets say G28 and will always be G28. The macro does not
use Find "Trials" and remember my keystroke patterns. Because if it did, the
destination of where I want my formula cell would always be different because
my "Trial" cell will be in different starting locations. The macro just
simply remembers the desitination cell and NOT how I got there.

"WillR" wrote:

Try

Application.GetOpenFilename

for the file open dialog

Can you elaborate a little more on what you need the FIND to do.

Usually, a google search using

Excel Find function VBA

would yield plenty of examples
--
Kind Regards,
Will Riley


"Chris" wrote:

I'm looking for a place where I can find VB code of macro examples.
Something along the lines of when you click the macro button, a file open box
pops up and prompts the user to open a file. From there, the macro uses Find
(ctrl+f) to find a few cells and then manipulates them. Any suggestions on
where I can find VB code examples? If the macro doesn't use Find, it's okay
but I would like to use the file open feature. Thanks.