Floating Text Box

Graebeard

New Member
Joined
Mar 21, 2015
Messages
23
Office Version
  1. 2019
Platform
  1. Windows
I've searched YouTube and Google looking for assistance, but not finding a satisfactory response anywhere. Hoping you folks may suggest a solution.

I have a monthly tab where I need to log daily entries and forecast dates for upcoming activities. Since the table takes up the first 8 columns, I want to put the current month's calendar in the right third of the screen. For this, I'm using an MS add-in.

The problem I have is that as I scroll down in my table, the calendar very quickly scrolls out of sight. So, I'm looking for a way to float the calendar above the table as it scrolls underneath. Since the calendar itself overlays about 10 rows, splitting the screen would limit the data table visibility.

I was hoping I could attach the calendar to an image and then use that image as a Form, and use the ShowModal false command to lift it off the table. I've read some info on this but not enough to create a user form, attach the app and give it lift-off.

Any ideas or suggestions would be greatly appreciated. Even after many years of using Excel, forms is something I have never needed, so I know very little about creating and using.

Thanks

Grae
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
You could download a 3rd party calendat that allows modality
See here
 
Upvote 0
You could download a 3rd party calendat that allows modality
See here

After reviewing some of those ideas, I opted for an excel addon date-picker as easier to apply and use.
 
Upvote 0
Found the solution

I downloaded and added the Mini Calendar and Date Picker by VERTEX42 and it came up with the name "Add-in 3". Could be any other name.
Then I added the following code to the Worksheet

Floating Picture.jpg


Not sure why the Dim statement is there as it works without it.

The position can be changed by altering the 10 and 650 to whatever you need.

Thanks to KAPONDROID at Excel VBA – Floating Buttons – KAPONDROID
 
Upvote 0
Solution

Forum statistics

Threads
1,223,246
Messages
6,170,996
Members
452,373
Latest member
TimReeks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top