SOLVED

VBA Command Button

Copper Contributor

Hello

I am new to VBA and I followed a youtube video to create a reset command button for my order form. I doubled checked the spaces and all but the button is not working. When I unclick Design Mode and try to select the button it takes me straight back to the code. So something is wrong there. The "Private Sub CommandButton1_Click()" is dark red colored which tells me something is wrong with that section? I am pretty for sure its a dumb newbie error.

 

Newbie so any help would be appreciated. Private Command Button Error.JPG

2 Replies
best response confirmed by Tamara Tiggs (Copper Contributor)
Solution

Hi Tamara,

 

The dark red color is called a Breakpoint.

It's used to stop the execution at a specific line of code for debugging purposes.

To clear that breakpoint, place the cursor on the colored line, then press F9.

Or you can click the red point on the left margin.

 

Hope that helps

Haytham

Thank you a million!!!!

1 best response

Accepted Solutions
best response confirmed by Tamara Tiggs (Copper Contributor)
Solution

Hi Tamara,

 

The dark red color is called a Breakpoint.

It's used to stop the execution at a specific line of code for debugging purposes.

To clear that breakpoint, place the cursor on the colored line, then press F9.

Or you can click the red point on the left margin.

 

Hope that helps

Haytham

View solution in original post