Automatically populate date to cell in Excel (with VBA)
I’ve create a VBA in Excel but would like to respective entries when data is added to automatically populate a date and time stamp in Column 3 of the worksheet. I was able to use a formula that worked if I manually entered information directly into the worksheet but I’d like for the field to populate if the data comes from the VBA macro.
I’ve create a VBA in Excel but would like to respective entries when data is added to automatically populate a date and time stamp in Column 3 of the worksheet. I was able to use a formula that worked if I manually entered information directly into the worksheet but I’d like for the field to populate if the data comes from the VBA macro. Read More