Search results

Sorry mate bit confused, I have the below code to check if the post code is valid Validcode = IsPostcodeValid(PostCode.Value) If Validcode = False And Validate = True Then Message3.initialise "This is not a valid Leicestershire post code!", "Ok" Message3.Show 'MsgBox "This is not a valid...

Morning, I currently have Excel 2007 at home but run 2003 at work the below code works brilliant to enable a form to minimise onto the windows toolbar and back again with 2007. However when I take it to work on 2003 it does work, basically when you minimise the form it does not appear on the...

I have been searching for a while but I can't find exactly what i'm looking for. Basically I have workbook which consists of valid post codes for the area (lets call it Postcode.xls). It is a large file and I am reluctant to open it due to network speed. I have a form run through another...

Cheers Brian this has given me some interesting options

:banghead:Morning, I'm trying to find a way to filter a worksheet with one value on two different columns, but failing! The below code works a treat to filter one column on the correct value Worksheets("Update").Range("R1").AutoFilter _ field:=18, _...

Bob, Thanks for that but i get exactly the same problem when the startupscreen.show line runs that it just brings up the startupscreen form and waits for the next input. Just to note that the startUp Screen is a form with four command buttons on it. I've changed the StartUpScreen.show to come...

Thanks for looking at looking at this Basically i open one workbook to run some code to create a tempory workbook and then run the tempory workbook and it should then close the origial workbook, whilst still being able to action the temp workbook! Simple Startprogram Workbook FileCopy...

Need some help with an application i'm writing. The problem that i have is that i have a to open different workbooks which isn't a problem however no matter what happens when i use the close function it stops by program from running. I've use ActiveWorkbook.Close, Workbooks(2).Close and...