ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Very basic VBA (https://www.excelbanter.com/excel-programming/351963-very-basic-vba.html)

knowtrump[_13_]

Very basic VBA
 

I think there are a lot of others who are like myself trying to get hel
with some things in VBA that are really very very basic. I want t
offer one way that I have found to get such help so that I can recor
it and then study it. Try this. Record or copy a Macro/Sub procedur
that contains the VBA terms that you are interested in studying. Ope
MSWord. Copy your macro (ControlC) and paste it(ControlV into the ope
Word document. Go back to your Macro, put the curser on the term yo
are interested in studying, Hit F1. Copy the Help topic that you ge
(ControlC) and go back to the open Word document and paste i
(ControlV) just below the term you want to study. If the Help topi
has an example, go back to the Help Topic, copy the example(ControlC
and paste it (ControlV) into the appropriate location of your wor
document. The Word Document now contains the term you want, th
definition of that term and an example that you can study at you
convenience. Hope this helps somebody. Let me know

--
knowtrum
-----------------------------------------------------------------------
knowtrump's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=50683



All times are GMT +1. The time now is 11:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com