+ Reply to Thread
Results 1 to 2 of 2

VBA code to click and double click

  1. #1
    Registered User
    Join Date
    01-26-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2013
    Posts
    93

    VBA code to click and double click

    Hi

    I want to click on a cell once and it places a "T" in that cell but if i double click it places a "A" in that cell..The range is A7:M125..if i double click on a cell and it places the "A" but i need to change to "T" i can then click on that cell once and it will change from "A" to a "T".....if i want to remove a letter i just hit delete key.....is this possible with VBA code?

    Thanks

    James
    Last edited by James__S; 07-02-2014 at 09:58 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA code to click and double click

    Yes it is, on the Worksheet Events in VBA
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. Click v double click event code
    By Greg J in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2014, 04:08 AM
  2. Changing cell properties with double click, then revert with another double click
    By mweber2525 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-01-2014, 01:40 PM
  3. VBA code to colour a cell on double click
    By rajys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 10:01 AM
  4. [SOLVED] userform label double-click goes to click event
    By John Paul Fullerton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2006, 01:00 PM
  5. Replies: 4
    Last Post: 08-02-2005, 09:05 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