Search results for query: *

=SUM(TODAY()) – date +1 On the excel spread setup your set your columns with “startDate” cell then from the excel DATA menu – select “Date & Time” then from the dropdown list select “Today”……. Then in the cell that you want the difference of the two dates you place the formula =SUM(TODAY()) –...

thanks guys - from all the input i was able to garner enough to set me on the right path......thanks again

Still a no-go ........i am using the Excel summation formula which comes out like this =Σ(Date() – 3/10/2013)+1 or =Σ(Today() – 3/10/2013)+1.......still does not work

Unfortunately i keep getting an error message with that formula - it did not work

An excel question ----I have a situation where a PICC is inserted in a patient – I want to count the number of days that the PICC is inserted until it is removed………for example – if the PICC was inserted on 3/10/2013 and removed on 3/23/2013 – I calculate the number of insertion days with this...

PVH writes - Why not do it manually with the macrorecorder on ? Mnnnnnnnn----- how does one record a macro and then get the "AND" operator in there?

Still having trouble - could you show an example? thanks

I am trying to select the “VRE” within the dates Below – but I cant get the “AND” operator to work - HELP Private Sub CommandButton1_Click() With ActiveSheet If Not .AutoFilterMode Then .[H2].AutoFilter Range("H2").Select Selection.AutoFilter Selection.AutoFilter Field:=6...

But is that a good reason to use it in THIS instance? i dont know - its just a thought i have - plus to do shortcuts - would have to go to everyone's PC. we have users 20 miles away loging in and sharing the same files - if i had one page with all the click events that all the users could...

Set up a DeskTop Folder with shortcuts to these files. No need to write code! plus knowing how to write such codes is a plus for me

Set up a DeskTop Folder with shortcuts to these files. No need to write code! true - but with little click events all on a single sheet - they could keep that sheet open and minimized and just click to open a file when needed - that would be neater and easier.

The problem is that personel in the office have difficulty locating and opening files - i would like to setup of Vb procedures with the file "description captions" so when people click them it opens the file for them Thanks

Private Sub CommandButton1_Click() ChDir "H:\PDOXSHAR\Monthly Reports 2009\MDRO rates Calc" Workbooks.Open Filename:= _ "H:\PDOXSHAR\Monthly Reports 2009\MDRO rates Calc\NOSOCOMIAL RATES KHD & PET 08.xls" End Sub The above procedure opens an Excel (.xls) file How...

This is an excel spreadsheet I want to select data where the "Culture Date" is > – this isent quite working Private Sub CommandButton1_Click() With ActiveSheet If Not .AutoFilterMode Then .[H2].AutoFilter Range("H2").Select Selection.AutoFilter Selection.AutoFilter Field:= 6...

This is an excel spreadsheet I want to select data where the “Culture Date” is > 12/31/2008 – this isent quite working Private Sub CommandButton1_Click() With ActiveSheet If Not .AutoFilterMode Then .[H2].AutoFilter Range("H2").Select Selection.AutoFilter Selection.AutoFilter...

I should edit my earlier instruction. Don't always say 'yes', always enable the macros. If it is worded "do you want to disable macro," you would answer 'no' in order to enable them. thanks - i will try that and see what happens - that could be the trick

Lower their VB Security settings. Don't set it to low, that could be dangerous. But select a setting where it will ask the user if they want to enable macros. Then tell them to say 'yes'. i did do the above but only on one PC did it work - all the others the question "do you want to disable...

Here is my problem I have several command buttons programmed to select different criteria as per the below examples. The spreadsheet is stored on a file server – the click_events works fine from my PC, but when I go to someones else PC the commands don’t work – I get the error message “Macro...

That almost worksed – I removed the 4th then the third and then the second -

Private Sub tmrFaces1_Timer() Static counter Select Case counter Case 0 imgFace(0).Visible = True Case 1 imgFace(1).Visible = True Case 2 imgFace(2).Visible = True Case 3 imgFace(3).Visible = True End Select counter = counter + 1...