Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Response to Frank: AM-PM Auto formatting
I did take a look at pearsons sight - might be helpful if I could do VBA,
maybe macros. (1) How about a trick of auto adding 12 hours withing the formatting? Possible? (2) Can I get a crash course - like 30minutes or less to be able to attempt either macros or VBA for this? Thank you Frank - BULAMAN |
#2
|
|||
|
|||
Hi
1) Not possible within a format. 2). Start with: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany BulaMan wrote: I did take a look at pearsons sight - might be helpful if I could do VBA, maybe macros. (1) How about a trick of auto adding 12 hours withing the formatting? Possible? (2) Can I get a crash course - like 30minutes or less to be able to attempt either macros or VBA for this? Thank you Frank - BULAMAN |
#3
|
|||
|
|||
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target If .Value < 1 Then If .Value < 0.5 Then .Value = 0.5 + .Value End If End If End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "BulaMan" wrote in message ... I did take a look at pearsons sight - might be helpful if I could do VBA, maybe macros. (1) How about a trick of auto adding 12 hours withing the formatting? Possible? (2) Can I get a crash course - like 30minutes or less to be able to attempt either macros or VBA for this? Thank you Frank - BULAMAN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |