Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form shows in the vba
I am trying to make a change to a form at work and it is one that someone
else created. When I go to the vba and the ViewObject and then right click on the form it actually activates, loads (shows) the form. What causes this. Is there a way I can make it so I can adjust the code behind the form. Thank you, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form shows in the vba
In the VBE, the small window in the upper left of the screen is the VBA
Project window. The form name should be listed in that window. Right click on the form name, then click View Object from the drop down menu. If it still shows the form on the sheet, there is probably a code snippet somewhere that is being used as a security method to prevent someone from changing the form. "Steven" wrote in message ... I am trying to make a change to a form at work and it is one that someone else created. When I go to the vba and the ViewObject and then right click on the form it actually activates, loads (shows) the form. What causes this. Is there a way I can make it so I can adjust the code behind the form. Thank you, Steven |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form shows in the vba
This is Steven,
What this issue is is that it is the calendar control tool. I am trying to make the startup postion be manual but it always reopens at the top left corner of the window. How do I make it so I can set the form where I want to keep it. Thank you, Steven "Steven" wrote: I am trying to make a change to a form at work and it is one that someone else created. When I go to the vba and the ViewObject and then right click on the form it actually activates, loads (shows) the form. What causes this. Is there a way I can make it so I can adjust the code behind the form. Thank you, Steven |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form shows in the vba
Have you tried setting the 'Startupposition' property of the 'UserForm'
-- If this post helps click Yes --------------- Jacob Skaria "JLGWhiz" wrote: In the VBE, the small window in the upper left of the screen is the VBA Project window. The form name should be listed in that window. Right click on the form name, then click View Object from the drop down menu. If it still shows the form on the sheet, there is probably a code snippet somewhere that is being used as a security method to prevent someone from changing the form. "Steven" wrote in message ... I am trying to make a change to a form at work and it is one that someone else created. When I go to the vba and the ViewObject and then right click on the form it actually activates, loads (shows) the form. What causes this. Is there a way I can make it so I can adjust the code behind the form. Thank you, Steven |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form shows in the vba
Hi Steven
You must set its Top and Left property (distance from screen top / left screen edge) before you show the form. The calendar control is in this context pretty much innocent. HTH. Best wishes Harald "Steven" wrote in message ... This is Steven, What this issue is is that it is the calendar control tool. I am trying to make the startup postion be manual but it always reopens at the top left corner of the window. How do I make it so I can set the form where I want to keep it. Thank you, Steven "Steven" wrote: I am trying to make a change to a form at work and it is one that someone else created. When I go to the vba and the ViewObject and then right click on the form it actually activates, loads (shows) the form. What causes this. Is there a way I can make it so I can adjust the code behind the form. Thank you, Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Result shows correct answer but cell shows 0 | Excel Discussion (Misc queries) | |||
cant change the cell format it shows too many different cell form | Excel Worksheet Functions | |||
sum shows (0.00) | Excel Programming | |||
Pass variable from form to form to form | Excel Programming | |||
cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions |