Search results

Excellent Monty... thank you

I have a main spreadsheet that houses many links to many other spreadsheets. Some of the other spreadsheets have not yet been created so they literally do not exist. I'm using the code shown below to update those links in the main-spreadsheet and that works perfectly fine but when it gets to the...

That I did not know. So, when you have both workbooks opened the formula works for you? I still get the #REF!, I guess I'll have to come up with a plan-B on this... thanks for the Hui

Attached are the two workbooks... 1422A-000 QCR has the formula you provided that is returning a #REF! in cell A5

Thanks Hui... I do completely understand your formula and it seems like it should work but it's not working for me, it's returning a #REF!. I tried a few tweaks but no change, what am I missing, do you have any ideas why it's not working for me?

I’ve attached two workbooks, we’ll call the 101A-000 the data file, the 1422A-000 has a reference to that data file. I simply want to create a formula in 1422A-000 that will update based on another cell, you’ll find more explanation on that in the spreadsheet. Thank you for looking and I greatly...

p45cal... you make that look easy, works great, thank you very much

The code below deletes conditional formatting in the entire row if "OPEN" appears in column-C, I'm trying to figure out how to get it to delete only in Column-D. For example, if C5 and C8 are the only ones that have “OPEN” in them then CF would be deleted in only D5 and D8. Any help will be very...

That's a thing of beauty, work's perfectly, thank you very much

This code checks cell B5 for a hyphen and if it’s there then it displays Commandbutton2, works good. I'm looking to modify it slightly so it looks in the entire column or a range like B5:B24 for example... thanks for looking, any help will be very appreciative. Private Sub...

VBA code converts the cell from formula to value. This is done to lock in the date... keeping the formula in tack will result in it continually updating to NOW(). Something I just discovered, if I open GraH-Guido's workbook the conditional formatting as he has it does work on my home Office 365...

David… what you describe is exactly what I’m shooting for. With the formula in column-D, when I select OPEN I get black font… should be red like you are seeing but it’s not. GraH… altering the condition as you have it changed nothing for me, still no red. If I use the opposing formulas I get...

I feel like a deer staring at headlights, I think I need a different set of eyes to look at this, what am I not seeing here? I'm using =ISFORMULA(D5) in a conditional format which should result in the font in the entire row to go red as long as D5 has a formula and then go Auto(black) once that...

OMG Kenneth, that was painless. You made something that I thought would be nearly impossible to do look incredibly easy even though to me it looks outrageously complicated. You should get an award, I can't thank you enough, this is the coolest VBA thing I have ever seen, Excel talking to my cell...

The idea is to click on an Excel ActiveX button that houses VBA code that sends a text message that reads “You have a new request” to cell phone numbers 2623700361@vtext.com and 2623703023@vtext.com followed by an Excel MessageBox that displays “Your Request Successfully Sent” Thank you for...

Hello again Deepak... your code is still working perfectly and although that is great news it hasn't had the overall effect I was hoping for. The goal was to stop the loitering and for most using the spreadsheet this has worked but there are some that walk away from their desk for long periods...

Okay guys, thanks for the confirmations, I'll explore other avenues, thank you for all your help

Hope this helps, thanks again for looking Below is in ThisWorkbook module Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) StopTimer End Sub Private Sub Workbook_Open() StartTimer End Sub Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)...

Logit... thank you for your input, just like the other examples I listed above including the "+ vbSystemModal" only causes the app button in the task bar to flash, it does not bring the message box on top of all other opened windows. vletm... no new case, yes I'm still trying to get my message...

Deepak... awesome, works perfectly, thanks again

Vletm... thanks but all that does is cause the app button in the task bar to flash just like these others AppActivate Application.Caption Application.Workbooks(ThisWorkbook.Name).Activate ThisWorkbook.Activate Application.WindowState = xlNormal AppActivate "Microsoft Excel"

Below is a line of code, when executed the message box does not appear on top of other windows that are open. Does anyone know if it's possible for this message box to always pop-up on top of all other opened windows? Thank you for looking, any help will be greatly appreciated. MsgBox "My...

Deepak... although your code is not influenced by idle time it can still serve the purpose, I just need to take a different approach, thanks again, I'm very appreciative.

I’m looking for some ninja level help here… I have found bits and pieces of this on several sites but I have not been able to put it together. I have people loitering in a spreadsheet, basically they open it and keep it open for no good reason which prevents others from accessing it, so I’m...

Luke M... the problem is I have another workbook that is looking for the updated value in WS-03 which would not be opened… but as Haz has confirmed WS-03 will not auto update/recalculate on its own... so I'm off to plan "B" for a solution. Thanks guys for your comments, they have helped me to...