Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can set break points and step through the code. You can add a watch to
variables. Set Break Point - click on line and press F9 step through code - Press F8 See value of variables Hover over the variable or add watch by highlighting a variable and right click. then select Add Watch It is easy todebug code by using intermediate variables. instead of function Myfunction(V1 as Integer,V2 as Integer,V3 as Integer) Myfunction = V1 + V2 / V3 end function Use function Myfunction(V1 as Integer,V2 as Integer,V3 as Integer) Myfunction = V1 + V2 Myfunction = Myfunction/ v3 end function Note the two functions give differnt results since multiplication is performed before addition Should be function Myfunction(V1 as Integer,V2 as Integer,V3 as Integer) Myfunction = V2/V3 Myfunction = V1 + V3 end function "NDBC" wrote: I have got my code for a user form working now. It has no technical code errors but I think one of the conditions in an if statement may be selecting incorrect cells. How can I check the values of different variables whilst it is running. I realise I could set up the code so it puts variables in set cells for checking but is there an easier way. I noticed when it took me to debugger when i was getting code errors before if i held my mouse over the variable names it would give me the current value. This is what I would like to be able to get. Can I get this without deliberately putting in code errors. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't turn off visual basic debugger in Excel 2003 | Excel Discussion (Misc queries) | |||
.show starts debugger upon window change | Excel Discussion (Misc queries) | |||
No Backspace key in VBA Debugger Help | Setting up and Configuration of Excel | |||
how do i turn off debugger and script editing | Excel Discussion (Misc queries) |