ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Floating toolbar and floating comment? (https://www.excelbanter.com/excel-programming/347327-floating-toolbar-floating-comment.html)

StargateFan[_3_]

Floating toolbar and floating comment?
 
I found this nifty invoice template that has a couple of very
interesting features. It has a floating toolbar with custom icons on
it and a large cell at the bottom that when you click into it, shows a
box with a floating comment. The floating comment seems much better
than the regular type of comment that a lot of users seem to miss.

The vb coding is restricted, however, with a password so I can't see
behind the scenes to how all this is set up. What are we looking for
when doing something similar, pls? I'd like to search on the net for
instructions on setting these two types of things up.

Thanks. :oD


quartz[_2_]

Floating toolbar and floating comment?
 
The comment sounds like an "Input Message" which can be set up through [Data]
then [Validation] on the main menu, see the [Input Message] tab.

The floating toolbar in code is called a CommandBar check VBA help and
search this forum for lots of example code.

HTH.

"StargateFan" wrote:

I found this nifty invoice template that has a couple of very
interesting features. It has a floating toolbar with custom icons on
it and a large cell at the bottom that when you click into it, shows a
box with a floating comment. The floating comment seems much better
than the regular type of comment that a lot of users seem to miss.

The vb coding is restricted, however, with a password so I can't see
behind the scenes to how all this is set up. What are we looking for
when doing something similar, pls? I'd like to search on the net for
instructions on setting these two types of things up.

Thanks. :oD



StargateFanFromWork[_3_]

Floating toolbar and floating comment?
 
"quartz" wrote in message
...
The comment sounds like an "Input Message" which can be set up through

[Data]
then [Validation] on the main menu, see the [Input Message] tab.


Perfect. That was it. I never realized that data validation was so
flexible. A new tool in my arsenal! <g It works perfectly and I prefer it
over the usu. comments.

The floating toolbar in code is called a CommandBar check VBA help and
search this forum for lots of example code.


Darn, wish I could see what the code is in this invoice example I have. But
it's neat to know what to look for now. I'll just have to hunt around for
examples.

Thanks so much.

HTH.


It did, thanks!

"StargateFan" wrote:

I found this nifty invoice template that has a couple of very
interesting features. It has a floating toolbar with custom icons on
it and a large cell at the bottom that when you click into it, shows a
box with a floating comment. The floating comment seems much better
than the regular type of comment that a lot of users seem to miss.

The vb coding is restricted, however, with a password so I can't see
behind the scenes to how all this is set up. What are we looking for
when doing something similar, pls? I'd like to search on the net for
instructions on setting these two types of things up.

Thanks. :oD





All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com