How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Insert floating text boxes in excel sheet

Customer Question

Insert floating text boxes in excel sheet
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  John D replied 4 years ago.

Hi,

 

There are several ways you can accomplish that. You can use a textbox, pop-up cell comment, a call-out frame. Which one would you prefer, and which version of Excel are you using

 

Alternatively if you could send me your file I will be happy to set it up for you

 

 

Customer: replied 4 years ago.

floating text box, so when i scroll the work sheet the text box does not move

Expert:  John D replied 4 years ago.

I am not sure if it can be linked to the scrolling action but I can write code to make a text box follow the selected cell. So when you click on a cell the text box will be displayed next to the selected cell

 

 

Customer: replied 4 years ago.

use a userform as a textbox that can float

Expert:  John D replied 4 years ago.

Ok test this file and let me know if that's what you are looking for so I can send you the code

 

http://www.filesharesite.com/files/201209/1346983966Floating_UF_test.xlsm

 

 

 

Related Microsoft Office Questions