+ Reply to Thread
Results 1 to 5 of 5

Change content of Cell using > BeforeDoubleClick

  1. #1
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Change content of Cell using > BeforeDoubleClick

    Hello all,

    I'm attempting to Modify some Code that changed the content of a Box using on Sheet Worksheet_BeforeDoubleClick.
    The characters Webdings fonts for ease of understanding for the User.

    The Idea is on DoubleClick of Target cell the character changes from:
    Ð >> Ï >>Ñ>>x

    Original: code can currently change between three characters.
    Please Login or Register  to view this content.
    Modified
    Please Login or Register  to view this content.
    I'm sure what sequence they should be after trying several variations.

    V/r,
    Jim
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Change content of Cell using > BeforeDoubleClick

    HTML Code: 

  3. #3
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Re: Change content of Cell using > BeforeDoubleClick

    BVM,

    I played with the order and I couldn't get past the third Character.

    Thank you for your time and help.

    V/r,
    Jim

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Change content of Cell using > BeforeDoubleClick

    use this code for debuging
    Please Login or Register  to view this content.
    and change letters after.

  5. #5
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Re: Change content of Cell using > BeforeDoubleClick

    BMV,

    Your Solution worked great! Sorry, I meant that I played with the order BEFORE you corrected the code. I just poorly worded my reply.

    V/r,
    Jim

    Thank you again for your time.

+ 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: 2
    Last Post: 01-17-2020, 12:16 AM
  2. Change content of one cell based on content of another
    By FloraLina in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-24-2014, 08:34 AM
  3. Change content of one cell based on content of another
    By stlellen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2014, 03:26 PM
  4. Change the content of a cell based on change the current date
    By aimanraya in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-14-2014, 07:07 AM
  5. Excel 2007 : Change the content of a cell
    By brantrumpel in forum Excel General
    Replies: 2
    Last Post: 02-20-2012, 11:03 AM
  6. Change ws3 Cell Content Depending On ws1 Content
    By heliskier89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2011, 04:52 PM
  7. Change cell content based from another cell's content
    By RochesterColonial in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2010, 03:43 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