|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 4th, 2004, 10:34 AM
|
|||
|
|||
|
Click Cell to Run VB Program
I have written a small program in VB within Excel and I want to run it every time I select a cell in one particular column. If I run the program it will return the value to the current cell. How can I start the program by selecting a cell?
Thanks.
|
|
#2
December 4th, 2004, 03:55 PM
|
|||
|
|||
|
Maybe VB has a Shell function in VBA. I don know much about Excel programming.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
#3
December 6th, 2004, 09:51 PM
|
|||
|
|||
problem solved
Thanks Doug G.. I found the solution. I used the Worksheet_SelectionChange event and checked for the column
selection. If the correct column was selected then I showed the userform that I built.
|
|
#4
April 19th, 2005, 06:53 PM
|
|||
|
|||
I have a very similar problem.
Quote:
I am using vb inside of xl. When I run my vb I have four buttons on a control panel and that is all I can access. I cannot click cells or scoll the xl display. How can I selct a cell while vb is running? How can I scoll the display? I want the user to be able to do these things while my program is running. I really appreciate any help you could give me. Best regards,
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Click Cell to Run VB Program |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
