VBA doesn't work after cutting & pasting controls onto a tab

[mkfloque]

Hello All, I had a form with many "loose" controls. I attached VBA to some of these controls (VBA was working fine). Then, when i cut & pasted controls onto a new tab, the VBA for each control stopped working.

Has anyone else had this problem?



thanks

[ranman256]

the vba does NOT copy with the control (thanks Microsoft)
you must copy/paste the vba afterwards, BUT if you copy the entire vba sub block,: like
sub btn_click()
code
end sub

then paste it all in the form, it will autmatically connect to the button, or combo, etc.

[mkfloque]

Thank you ranman!!!

[John_G]

Two things to look for:

First - When you cut-and-paste a control, its name often changes, but the VBA code does not get changed to match, so you have to either edit the VBA code to match the new name, or rename the control back to its old name (but see the next comment)

Second, when you cut and paste a control, the Event properties (which are usually set to [Event Procedure] ) are cleared, but the code remains. If the control name is the same as it was, then resetting the event property to [Event procedure] will restore the link to the code.

[mkfloque]

John...resetting the event property worked perfectly (as the control names didn't change). Thx so much for the tip