| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for floating button
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
Place the button in row 1 then freeze panes.
Gord Dibben MS Excel MVP On Thu, 21 Jan 2010 08:12:04 -0800, Gilbert wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
An alternative is to put the button on a custom toolbar, since toolbars are
easy to float. -- Gary''s Student - gsnu200909 "Gord Dibben" wrote: Place the button in row 1 then freeze panes. Gord Dibben MS Excel MVP On Thu, 21 Jan 2010 08:12:04 -0800, Gilbert wrote: 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? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
Put it on a modeless userform. Or onto the ribbon.
HTH. Bst wishes Harald "Gilbert" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
I apologize for not responding sooner but I still wanted to thank you for
your suggestion. "Gord Dibben" wrote: Place the button in row 1 then freeze panes. Gord Dibben MS Excel MVP On Thu, 21 Jan 2010 08:12:04 -0800, Gilbert wrote: 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? . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
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? "Gary''s Student" wrote: An alternative is to put the button on a custom toolbar, since toolbars are easy to float. -- Gary''s Student - gsnu200909 "Gord Dibben" wrote: Place the button in row 1 then freeze panes. Gord Dibben MS Excel MVP On Thu, 21 Jan 2010 08:12:04 -0800, Gilbert wrote: 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? . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
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? "Harald Staff" wrote: Put it on a modeless userform. Or onto the ribbon. HTH. Bst wishes Harald "Gilbert" wrote in message ... 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? . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
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. Gilbert wrote: 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? "Harald Staff" wrote: Put it on a modeless userform. Or onto the ribbon. HTH. Bst wishes Harald "Gilbert" wrote in message ... 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? . -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for floating button
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.) Dave Peterson wrote: 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. Gilbert wrote: 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? "Harald Staff" wrote: Put it on a modeless userform. Or onto the ribbon. HTH. Bst wishes Harald "Gilbert" wrote in message ... 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? . -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| floating button | Excel Discussion (Misc queries) | |||
| Floating Stop Recording Macro Toolbar | Excel Discussion (Misc queries) | |||
| Floating button | New Users to Excel | |||
| Floating command button | Excel Discussion (Misc queries) | |||
| Missing floating Macro Toolbar. Can't change to relative referenc | Excel Discussion (Misc queries) | |||
Linear Mode
