Macro for floating button

  • Thread starter Thread starter Gilbert
  • Start date Start date
G

Gilbert

I created a macro and assigned it to a form button in excel 2007. What I
would like if for this button to move (up or down) the same direction that
I'm scrolling. Is this possibly?
 
An alternative is to put the button on a custom toolbar, since toolbars are
easy to float.
 
I apologize for not responding sooner but I still wanted to thank you for
your suggestion.
 
I apologize for not responding sooner but I still wanted to thank you for
your suggestion. But how can I make the toolbar float in 2007?
 
I apologize for not responding sooner but I still wanted to thank you for
your suggestion. I'm not familiar with modeless userform, how do I use that?
 
If all your users are running xl2k or higher, you can add a parm on the .show
statement.

UserForm1.Show False

See VBA's help for more info.
 
Actually, excel's VBA has its own constants for use with .Show.

Constant Value Description
vbModal 1 UserForm is modal. Default.
vbModeless 0 UserForm is modeless.

So I should have suggested:
UserForm1.Show vbmodeless

(False will be treated as 0, so it'll work, but it's less descriptive.)
 
Back
Top