View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Adding a watch expression in VB

Left Click on the subroutine (any place) then start macro F5- Run F8-Step

"Mahadevan Swamy" wrote:

All the VB codes are written in a module and I don't know how to
execute this module. When I try to press Run button, I get to run some
other macro but not this module. In a module I have different
functions and I want to execute those functions. Is there a way to
do that?

Thanks
Swamy


On May 31, 11:48 am, Joel wrote:
the values will be out of contextt until the macro is run. Put a break point
(F9) where the variables are used and then run until break point is reached.
The look at the watch.

"Mahadevan Swamy" wrote:
Hi,


I am using VB and excel and I would like to know how to add a watch to
an expression in VB for some lines of code. When I select a value in
excel and add a watch on a variable, I get Value: <Out of Context.
Could somebody please explain how to add a watch expression properly
when i select a value in excel. Thanks in advance.


Swamy