Posted to microsoft.public.excel.programming

Patrick Simonds Patrick Simonds is offline

external usenet poster

Posts: 258

Using a time value in a macro

In the place of the 30 in the formula below, I need to enter the time value
of 00:30 but the macro errors out as soon as I do this.

ElseIf Cells(1, 13).Value = 30 Then
OptionButton2.Value = Tue

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro / function text time to 24hr excel time passed midnight fortotaling hr's	Russmaz	Excel Worksheet Functions	2	March 6th 09 04:58 AM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
Help with Macro to Convert Date/Time to Time Only	Bill[_26_]	Excel Programming	5	August 25th 04 01:50 PM
excel - macro - automatic initiation of a macro at a pre-specified "system time"	arunjoshi[_3_]	Excel Programming	3	May 1st 04 09:42 AM

All times are GMT +1. The time now is 06:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us