Event Log

[Rookwood]

Hi,

I have a few vehicle at my work which people take at random times. I am wondering is it possible to have a spreadsheet where the sheet shows

Which car (drop down window)
Person taking car
Reason for taking car
Time Out
Expected Return
Time In

These would have a field box next each question.

After the info is entered they hit a 'GO' button or such. It then updates that info to a second sheet or multiple sheets that correspond to the car rego.

Once they hit go they question fields empty and the next person can enter the details?

Preferably i would like to do this with formulas not VBA as I dont know VBA.

 

[Logit]

In case you want to try a macro approach :

Simple Database.xlsm

 

[Rookwood]

In case you want to try a macro approach :

Simple Database.xlsm

how can i modify this I just tried, opening the VBA window and adding more of

ws.Cells(newRow, 2).Value = Me.txtDriver.Value

changing the green text to the question. didnt do anything.

 

[Logit]

Is there a textbox on your userform named txtDriver ?

Just to cover it, in case there might be a question .... Me refers to the UserForm. The code goes in the UserForm code module.

txtDriver would be the name of a textbox on the UserForm.

txtDriver should be followed with the term Text. Me.txtDriver.Text

Data located in a TextBox are referred to as .Text
Data located in a cell are referred to as .Value