If c.Left + c.Width > w Then w = c.Left + c. If c.Top + c.Height > h Then h = c.Top + c.Height If Sheets("Form").Range("F11").Value = 1 Then I have an alternative of creating 3 types of forms and use the when needed but i want to move it to the right place and then auto-adjust the form (i have applied the macro already for auto-adjusting). I tried this but my object disappears rather than moving. Move property which can be used to do this. I know the exact position on my userform where it should be placed. I want to make sure that there's no blank space on my userform and i would like to replace the blank space with. When I open the Developer tab, click on Visual Basic, and then go to the Insert menu, my only option is to add a module or class module. I actually want to hide/unhide objects which works well but as soon as an object is hidden the space is left BLANK. User Form in VBA for Excel in Office 365 for MAC I am attempting to build a User Form in VBA for Excel with MS Office 365 for MAC. Im trying hard to find a solution to move a Frame to a defined place in my vba Userform.
0 Comments
Leave a Reply. |