+ Reply to Thread
Results 1 to 3 of 3

Display active cell value

  1. #1
    Registered User
    Join Date
    03-03-2014
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Display active cell value

    Is there a way to get a cell to display the value in the active cell without using VBA?
    I've got it working with VBA but just wondered whether it was possible to do it another way, as I would like to embed this worksheet in a webpage if possible.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Display active cell value

    Hi serentan,

    Not sure what you mean?

    If you want to use the resulting value from a Formula in another Formula, you can use INDIRECT(ADDRESS ...

    It might help if you post your VBA solution.

    Thanks
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    07-18-2013
    Location
    Denver, CO
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Display active cell value

    If you use cell protection and make the cell hidden, the formula will be hidden to the user when the workbook is protected. Could that help you?

+ 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. Subtract cells from data entered and display result in active cell.
    By ccloudy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2013, 04:17 AM
  2. [SOLVED] Display contents of multiple active cells in another cell?
    By mtsykes28 in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 11:27 AM
  3. Display Active Character Count + Limit Character Per Cell
    By euronail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2011, 04:59 AM
  4. Active cell not on display after enter
    By yoriko in forum Excel General
    Replies: 0
    Last Post: 10-12-2009, 10:23 AM
  5. [SOLVED] program cell to display any character when cell is active
    By David is learning in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2006, 03:00 PM

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