+ Reply to Thread
Results 1 to 2 of 2

Creating a Floating Text Box

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Reading, England
    MS-Off Ver
    Excel 2010
    Posts
    81

    Creating a Floating Text Box

    I'm trying to create a floating text box for my spreadsheet, I've created individual labels but when I run it VBA does like what I've done.

    I've attached a snipping of what is created and what VBA is doing.

    Basically, the information in the text box will never change and I just need it to float to give people who go into the sheet an idea what the coloured lines mean.

    I've only a real basic knowledge of VBA so any help will be greatly appreciated.

    Thanks In Advance
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    09-13-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Creating a Floating Text Box

    Hi

    Go to data validation & put custom message.

    As soon as cell is selected, message will appear..

    Cheers!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Floating Text Box
    By MatthewIJClark in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2013, 11:45 AM
  2. How to add a floating text box in 2007
    By zhuowang1980 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2013, 03:54 PM
  3. Creating a floating text box containing a hyperlink
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-01-2013, 10:26 AM
  4. Floating Text Box
    By Phil Walters in forum Excel General
    Replies: 3
    Last Post: 11-12-2012, 06:06 AM
  5. Inserting adding or creating a floating text box on Chart
    By riwiseuse in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-02-2010, 10:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1