PDA

View Full Version : Solved: Modifying a User form



austenr
04-23-2007, 01:47 PM
Hi,

I have a user form that I modified. I added some extra text boxes and labels. When I save it and try to call it, the old form tries to appear. Anyone else encounter this before?

Jacob Hilderbrand
04-23-2007, 09:21 PM
Is the old form still there and you are showing the wrong form, or are you really showing the new form but the old one appears?

Can you post an attachment?

austenr
04-24-2007, 05:47 AM
Hey Jake...There is only one form in the WB. When you open it the old form appears. Im attaching the WB.

lucas
04-24-2007, 07:18 AM
I don't know what the old form looks like but this is what I see when I click the button....it looks just like the form in the vbe

austenr
04-24-2007, 07:26 AM
yes thats the form. Try adding a text box to it and see if you get an error. Seems simple enough to add a text box and expect a revised form to show up with the new text box added. :dunno :banghead:

lucas
04-24-2007, 07:32 AM
I didn't have any problem adding a textbox....
from the button after adding a textbox:

Aussiebear
04-24-2007, 07:35 AM
Hi Austen, I added a text box and it shows up, no error messages etc.

austenr
04-24-2007, 07:45 AM
To Weird.

Aussiebear
04-24-2007, 07:54 AM
I like the look of the blinking scroll bar. Never seen that before.

Jacob Hilderbrand
04-24-2007, 08:43 AM
I was able to add a textbox ok as well. Maybe there is something corrupt in Excel. You can try the detect and repair, then uninstall, reinstall office.

austenr
04-24-2007, 08:49 AM
OK thanks everyone. I'm going to mark this as solved becuase it is most likely something other than user error.

jolivanes
04-24-2007, 12:26 PM
austenr.
I don't know if you have the same problem but when I open the UserForm and close it right away without entering/changing anything, it deletes a row in the "instructions" sheet. Select cell J12, open the UserForm, click on the close button and one row will be deleted (on my compter anyway). Continue opening and closing will continue deleting rows. Again, on my computer it does this.
John

austenr
04-24-2007, 12:59 PM
Hi,

Yea I noticed that too. I ended up trashing the WB and recreating what I needed. Was trying to take to lazy way out but found it faster to just re do it.

:ohwell: