Adding new records through a userform - Specifically Date

W

Wes

Board Regular
Joined
Jan 30, 2004
Messages
195
I have a userform that is set up to work as a front end for collecting daily information. It can add records, view previous next etc...

One of the text boxes is for the date.

I would like to have the date automatically added when I click on the new button.

The new date would have to be added to the previous one in my records located in cell a5 on the Daily Information sheet.

Any guidance would really be appreciated. :rolleyes:
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
You must log in or register to reply here.

Similar threads

P
  • Question
Listbox Filter Search
Replies
5
Views
229
Pacman52
P
I
  • Solved
Textbox on userform not updating when navigating through records
2
Replies
10
Views
341
ipbr21054
I
A
  • Question
Ideas how to display a filtered list …
Replies
8
Views
429
igold
igold
O
  • Question
Save file to a new name using excel vba
Replies
1
Views
242
PeteWright
PeteWright
S
  • Solved
Date missing leading zero even with date format of dd/mm/yyyy in Excel
Replies
2
Views
351
Surreybloke
S

Forum statistics

Threads
1,221,206
Messages
6,158,526
Members
451,497
Latest member
something68

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top