Visual Basic SOS from lady in distress.

Paulasirius · May 6th, 2002, 03:36 AM

How do I use Visual Basic code?
This may seem a strange question to those who are used to Excel, but to me it is a mystery.
I know about syntax and structure from the help files and from previous Basic usage on my old 8-bit Amstrad. So I can write the code. But how the hell do you USE the code once you have wriiten it? I have spent hours and hours and hours trying to understand how to install and use Visual Basic code into my Excel applications, but I am damned if I can find out how.
So all you clever and experienced guys out there, how about helping this damsel in distress before she gives up programming for needlework and places some Semtex under her computer........not being able to put some under good old Bill G!!

waderw · May 6th, 2002, 07:39 AM

Try creating a "command button" from the "toolbox" and the right clicking on the button and "Assign macro". Then point to the procedure you wish to start your macro.

Hope this gets you started. If not look in the help files for "macros, buttons".

That should get you started.

Regards and Good luck!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 03:36 AM	#1
Paulasirius New Member Join Date: Feb 2002 Location: Eastbourne Posts: 8	How do I use Visual Basic code? This may seem a strange question to those who are used to Excel, but to me it is a mystery. I know about syntax and structure from the help files and from previous Basic usage on my old 8-bit Amstrad. So I can write the code. But how the hell do you USE the code once you have wriiten it? I have spent hours and hours and hours trying to understand how to install and use Visual Basic code into my Excel applications, but I am damned if I can find out how. So all you clever and experienced guys out there, how about helping this damsel in distress before she gives up programming for needlework and places some Semtex under her computer........not being able to put some under good old Bill G!!

May 6th, 2002, 07:39 AM	#2
waderw Board Regular Join Date: Apr 2002 Posts: 85	Try creating a "command button" from the "toolbox" and the right clicking on the button and "Assign macro". Then point to the procedure you wish to start your macro. Hope this gets you started. If not look in the help files for "macros, buttons". That should get you started. Regards and Good luck!