UserForms

[ExcelRoy]

Hi All,

I wonder if you could answer a question about userforms

I have the form set to automatically show, but it always is situated in the centre of the screen

is there a way to set it from say B6?

Many thanks

 

[James006]

Hi,

Chip Pearson has desgned a Form positioner :Form Positioner

HTH

 

[Caribeiro77]

Hi All,

I wonder if you could answer a question about userforms

I have the form set to automatically show, but it always is situated in the centre of the screen

is there a way to set it from say B6?

Many thanks

When i want to do something like that i do it manually going to:

Form properties
Startup position ad change it to manual
and then change the top and letf propertie untill i get the positioning i want..

 

[ExcelRoy]

Hi James,

He's just too clever, thanks for the link

Caribeiro77,

That's perfect, thanks

 

[ExcelRoy]

Another question if I may,

Using userforms, can the Tab key be used to move to the next textbox

at the moment it just tabs across the same textbox

Thanks

 

[James006]

Chip's code is very handy if you need the UserForm to "stick" to the ActiveCelll

 

[Caribeiro77]

Right-click on top of the userform and then taborder...

 

[ExcelRoy]

Many thanks