2 questions! Related to combobox and time function. HELP!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi there!
I have 2 problems in excel and I count with your help because i don't know
the best way to solve them.

1 - I need to do something like a combobox from where i select one text from
others. How do i do this? Is it possible to do it with lists?

2 - I need a funtion or anything that tells me the precise time hh:mm:ss i
write it and doesn't get updated each time change my file like =now() ? How
do i best do this? (it's to meant to monitor the lenght of phone calls)


Hope you can hel me

Bruno
 
1. Have a look at Data/Validation/List, perhaps that's you are looking for!
2. Pressing Ctrl+: enters current time in the active cell.

Regards,
Stefi

„Bruno†ezt írta:
 
1. Have a look at Data/Validation/List!
2. Pressing CTRL+: enters current time.
Regards,
Stefi


„Bruno†ezt írta:
 
Stefi said:
1. Have a look at Data/Validation/List, perhaps that's you are looking for!
2. Pressing Ctrl+: enters current time in the active cell.
Click to expand...


1
Where do i check Data/Validation/List ??

2
Ctrl+: solved the problem. Thanks!!!!
Although can you tell me if it works in OpenOffice?
 
1. Data menu/Validation submenu/Choose List from the drop down list.
2. As far as I know No, but perhaps you can use the NOW() function, because
it is not updated automatically in OpenOffice.

Regards,
Stefi

„Bruno†ezt írta:
 
Ok i already solved problem 1!!

Problem 2 is resonably done but i would like to make it more acurate.

The Ctrl+: gives me the correct hh:mm but it doens't give me the seconds
even if i chose hh:mm:ss it shows like 11:41:00.

Is there anything i can change in my EXCEl to give the seconds?
 
Ok i already solved problem 1!!

Problem 2 is resonably done but i would like to make it more acurate.

The Ctrl+: gives me the correct hh:mm but it doens't give me the seconds
even if i chose hh:mm:ss it shows like 11:41:00.

Is there anything i can change in my EXCEl to give the seconds?
 
Unfortunately I could find only a workaround method, a Change event macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$1" Then 'adjust reference as required!
Target.NumberFormat = "hh:mm:ss"
Target.Value = Time
End If
End Sub

Type anything in cell D1, hitting Enter will store current time with seconds.
Regards,
Stefi

„Bruno†ezt írta:
 
I tried the code would gave me it worked fine for one cell but it doesn't
work for things like $D$1:$D$10.

Is there anyway to return the seconds along a column with that code?
 
This version works for all cell in column D:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 Then '4th (D) column
Target.NumberFormat = "hh:mm:ss"
Target.Value = Time
End If
End Sub

Regards,
Stefi

„Bruno†ezt írta:
 
Thanks I replaced this new version of code instead of the 100s of if's i had
copied and it works FINE!!!!!!!


THANK YOU VERY MUCH FOR YOUR HELP STEFIE ;) ********
 
Back
Top