Posting time stamp and username using command button

Hello,

I am trying to set up a daily checklist for my team. I am a beginner with VBA and need help. I would like to have a command button that when clicked performs the following on the active cell:

enter username
enter time
locks cell after so it can not be modified.

can someone please help with this issue.

Thanks,
MCav16

Hi

I have created something for you.

the Activex button hides a simple macro

Please Login or Register  to view this content.

Alternatively you could create form button and link it to a macro in a module:

Please Login or Register  to view this content.

I have listed a list of usernames in a sheet called "Usernames"

Userform1 holds a Listbox that lists all the usernames in column A

Clicking on this listbox inserts the selected username and the time in the active cell.

Please Login or Register  to view this content.

You can import the userform to any work book

by opening my spreadsheet,
opening visual basic
selecting view project explorer
right clicking on the userform
selecting export.

closing my spreadsheet

opening your spreadsheet
opening visual basic
selecting view project explorer
right clicking on the left of the screen where the sheets are listing
selecting import.

This is the spreadsheet.