Results 1 to 3 of 3

How to switch between two cells using VBA?

Threaded View

  1. #1
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    22

    Question How to switch between two cells using VBA?

    As you can see in the attached file, I have two different dates: one is set manual and one is automatic using "today" function. There is another cell called "project start date" which is linked to B1 which is a manual date. from time to time, I change "project start date" from one to another. Now, I want to be able to shift the content of project start date" from manual to automatic or vice versa using a button (which I suppose would be possible using "insert control").
    Attached Files Attached Files
    Last edited by blakroz; 01-30-2021 at 06:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do you link a whole page of cells to one cell
    By KSharpley in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-01-2020, 04:04 AM
  2. Replies: 9
    Last Post: 02-12-2015, 03:53 AM
  3. [SOLVED] How to link cell values in different cells.
    By general_IHD in forum Excel General
    Replies: 2
    Last Post: 11-24-2014, 08:14 PM
  4. Link a cells value to specific name given in another cell
    By grekis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2013, 01:03 PM
  5. select cell a1 then link with cells b1:h13
    By number novice in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 08-25-2011, 12:49 AM
  6. How do I link many cells to one particular cell?
    By fish@divi in forum Excel General
    Replies: 4
    Last Post: 01-05-2005, 07:48 AM
  7. How do I link many cells to one particular cell?
    By justinfishman22 in forum Excel General
    Replies: 2
    Last Post: 01-03-2005, 09:06 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