Recent content by 8177

Hi Guys I have a list of field names in a value list; I have set a global value to contain a value from this list What I want to do is click a button select the value from the global and use it to go to the selected field Thanks in advance

Thanks Guys this has helped immensely, i can now keep my boss happy for a few more days (whopps i meant hours)

Hi Guys I have a model that contains many sheets (these sheets have various names that do change), what i need to do is move from sheet1 to the last sheet in the model in turn using VBA, something like next sheet Any Ideas

Thanks Guys worked a treat

Hi Guys Any ideas on how i can do this the criteria part of the forumla contains Vanilla and not just vanilla on its own we could have Vanilla IT Vanilla S & S Vanilla and i need to return the result of all these SUMIF(A:A,"vanilla",B:B)

Cheers Guys thanks for your help they work great

Hi Guys I need to find out if the autofilter is On or Not I have tried Public Sub t() Sheets("Effort").Select If AutoFilter.Active Then MsgBox "On" Else MsgBox "Not On" End If End Sub also Public Sub t() Sheets("Effort").Select If AutoFilter = True Then MsgBox "On" Else MsgBox "Not On" End...

You guess right as we want to hard code the server location, saving as web will rely on the user to enter the correct location (mm danger)

Hi Guy I'm new to VBA in Outlook and have been tasked to write some code that will save the calendar as a web page on a file server, and guess what i have know idea how. any ideas Malc

Thanks for this its a great help Malc

Thanks Pampers i tried this yesterday, however the tip stays the same no matter which switchboard you look at switchboard 1 button 1 has the same tip as switchboard 2 button 1 Malc

Hi Guys Does anybody know if you can change the ControlTip Texts within the switchboards depending on which switchboard you are looking at If so how?

Hi Guys Does anybody know if you can change the ControlTip Texts within the switchboards depending on which switchboard you are looking at If so how?

Hi Guys Does anybody know of a way I can stop users from pasting data in to fields (Memo), as they keep pasting carriage returns etc

Thanks lespaul faq181-261 works a treat many thanks for your help