+ Reply to Thread
Results 1 to 4 of 4

Default value in cell

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Default value in cell

    Hi all, how do I change this to having the word 'greyscale' by default in the cell and rest stays the same (so click on it and it will change to 'bitmap' and click again to get 'greyscale')?

    If Not Intersect(Target, Range("N3:N25000")) Is Nothing Then
    If Target.Count > 1 Then Exit Sub
    If Target.Value = "Greyscale" Then Target.Value = "Color" Else: Target.Value = "Greyscale"
    End If

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Default value in cell

    Copy this code in the code module of the worksheet.
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Re: Default value in cell

    Thank you, Tsjallie. I have to say it's not quite what I meant but it is very useful anyway.

    This code will immediately change the cursor to be on the left of the cell I just clicked - which is helpful because then you can click twice to change the value - but what I meant is having the values as a default in the cell.

    Thank you anyhow!

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Default value in cell

    Ah, that way.
    You could add this sub to the worksheet's codemodule.
    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 12-10-2013, 01:44 PM
  2. Replies: 3
    Last Post: 10-16-2013, 07:17 AM
  3. [SOLVED] How to make a dropdown list cell default to blank, after another cell selection is made
    By chardsmith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2013, 03:46 AM
  4. [SOLVED] default cell value
    By madhatter40 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 11:31 AM
  5. Replies: 1
    Last Post: 08-10-2012, 10:01 AM
  6. Prefill MonthDate,Clear cell & Default to last blank cell
    By SVTF in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-17-2011, 10:08 PM
  7. Insert cell A value into default text cell D for each specific row
    By badasstoymaster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2010, 03:40 PM
  8. Replies: 2
    Last Post: 11-17-2008, 09:14 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1