+ Reply to Thread
Results 1 to 2 of 2

Change event procedure

  1. #1
    Registered User
    Join Date
    12-05-2010
    Location
    Sydney Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Change event procedure

    I am struggling with Excel 2010 VBA. I have some checklists that various people will provide input to. I want to:
    1. enter text into a box (or activate a macro to do that, such as Ctr d ="Done", or Ctr n = "N/A") and then 2. have the cursor move to the cell in the next column and type the Application.UserName and then
    3. have the cursor move to the cell in the next column and type the current date.

    I can do steps 2 & 3 but can't work out how to do Step 1 automatically. I understand that it is something that responds to a change in the worksheet/cell, Also I need to make sure that when a different user accesses the worksheet the UserName does not change.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Change event procedure

    Hi GarryPritchard
    Welcome to the forum
    one way maybe to add this code to the worksheet module
    Please Login or Register  to view this content.
    when the user clicks in the target range a1 to A10 the data will auto fill
    hope it helps
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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