| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH CODE
I am using this code to transfer times from a userform to my template, The
trouble is when I click on any of the cells it automatically places 00:00 in the cell which then causes a conflict on my other sheet's "if" code any help would be appriciated. Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Text = Format(TextBox1.Text, "00:00") End Sub Thanks in advance Greg |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP WITH CODE
Hi Greg
not really understanding what's going on here .. if you'ld like to zip up the workbook and email it direct to me i'll be happy to take a look - julied at hcts dot net dot au Cheers JulieD "Greg Brow" wrote in message ... I am using this code to transfer times from a userform to my template, The trouble is when I click on any of the cells it automatically places 00:00 in the cell which then causes a conflict on my other sheet's "if" code any help would be appriciated. Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Text = Format(TextBox1.Text, "00:00") End Sub Thanks in advance Greg |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP WITH CODE
Thanks for the offer,
Unfortunately I realised I was wrong. The problem never occured again so I assume it was me. Thanks again Greg "JulieD" wrote in message ... Hi Greg not really understanding what's going on here .. if you'ld like to zip up the workbook and email it direct to me i'll be happy to take a look - julied at hcts dot net dot au Cheers JulieD "Greg Brow" wrote in message ... I am using this code to transfer times from a userform to my template, The trouble is when I click on any of the cells it automatically places 00:00 in the cell which then causes a conflict on my other sheet's "if" code any help would be appriciated. Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Text = Format(TextBox1.Text, "00:00") End Sub Thanks in advance Greg |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP WITH CODE
Hi Greg
glad it's solved. Cheers JulieD "Greg" wrote in message ... Thanks for the offer, Unfortunately I realised I was wrong. The problem never occured again so I assume it was me. Thanks again Greg "JulieD" wrote in message ... Hi Greg not really understanding what's going on here .. if you'ld like to zip up the workbook and email it direct to me i'll be happy to take a look - julied at hcts dot net dot au Cheers JulieD "Greg Brow" wrote in message ... I am using this code to transfer times from a userform to my template, The trouble is when I click on any of the cells it automatically places 00:00 in the cell which then causes a conflict on my other sheet's "if" code any help would be appriciated. Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Text = Format(TextBox1.Text, "00:00") End Sub Thanks in advance Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| option buttons run Click code when value is changed via VBA code | Excel Programming | |||
| VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
Hybrid Mode
