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
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: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.



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 5 years ago.

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

Expert:  John D replied 5 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 5 years ago.

use a userform as a textbox that can float

Expert:  John D replied 5 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