+ Reply to Thread
Results 1 to 5 of 5

Get string in Comment Box to show as cell value

Hybrid View

  1. 03-18-2018, 01:48 PM #1
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Get string in Comment Box to show as cell value

    Sorry my mistake, should be

    .Text Format(Arr(4, i), "#,##0.0") & " - " & Arr(5, i) & " - " & Format(Arr(6, i), "#,##%")

    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  2. 03-18-2018, 01:53 PM #2
    soidog
    soidog is offline
    Registered User
    Join Date
    10-30-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    30

    Re: Get string in Comment Box to show as cell value

    Excelent!
    I have tried for two days now so I am very thankful for your help.
    Thanks a lot!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] show/hide comment does not appear when right clicking on cell
    By flupsie in forum Excel General
    Replies: 3
    Last Post: 01-21-2018, 07:36 AM
  2. [SOLVED] Function to return comment from a cell, or null string if no comment
    By Monkihunta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2017, 01:01 PM
  3. [SOLVED] Show comment on mouse over cell rather than over comment icon....?
    By BellyGas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2015, 09:05 AM
  4. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  5. [SOLVED] Can't show cell comment text in Msgbox
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2012, 05:51 AM
  6. Cell Comment Truncating String?
    By bstubbs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2009, 03:02 PM
  7. [SOLVED] Formatting decimal to show in a cell comment with VBA
    By Bobby in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 02:45 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1