hi kadghar - i'm running the code within excel.
to save you putting a lot of time into fixing this, though - i've decided to use AddComment instead, it's working fine and seems to do the job. However, if you have any insight into the problem and want to share it, then please feel free - it's all good learning, for me....
Lara1
Last Activity: Aug 20 '08, 11:26 PM
Joined: Jan 11 '08
Location:
-
I already saw that article, before I posted. Trouble was, I couldn't understand any of it :-(
A colleague of a friend has said he thinks the problem is to do with the use of validations, which are complicated (and use external code?). So now i'm trying to figure out how to use shapes with text in, instead of input messages.Leave a comment:
-
Okay, following a bit more investigation - the problem ONLY happens when i try to run code sample 2 (see previous post, above) from a button. If I run it from a SheetChange event, or just by itself, it works perfectly.Leave a comment:
-
Yup, the missing target was the problem. I'd even figured it out myself just before you posted (!!!). The code now runs perfectly, and you are a star.Leave a comment:
-
Lara1 started a topic Validation not working: run-time error '-2147417848 (80010108)'in Visual BasicValidation not working: run-time error '-2147417848 (80010108)'
I'm trying to get certain cells to show a hovering alert message when I click on them. (I don't want an error-message style box to pop up, because I'll eventually want it to show for lots of cells at once.)
I recorded a macro to get the code, which I tweaked minimally, and pasted into a clean spreadsheet to test it. It seems to work beautifully. However, when I try to apply the same code within a larger programme, in a working spreadsheet,... -
Thanks again for helping out, Mike. Not quite there yet, but maybe you'll know why?
I tried this but it didn't seem to do the trick, so I figured I'd abandon my code and try out yours.
Line 6 appears to have a big space at the end of it, before the .Row. The VBE didn't like that so i ran .Row onto the end of SpecialCells(xl CellTypeLastCel l)
But it still isn't quite...Leave a comment:
-
VBA Excel SheetChange event - nothing happens when i make the change
I'm trying to write a procedure that will enable button on a sheet (and colour it red), but ONLY when changes are made to cells in column E of that sheet (from row 10 to the bottom of the used-range).
However, at present, when I edit a cell in column E, nothing happens to the button (it is currently grey and disabled).
I've tried using Microsoft's VBA online help, and also my bible (Excel VBA for dummies) but haven't... -
HTH, many thanks for the response (I only just saw it). You were right of course :-)Leave a comment:
-
Hi, I'm in trouble again.
This time, I'm trying to amend my procedure so that it will work through the spreadsheet line-by-line, checking the values in columns D and E, and selecting appropriate values to enter into columns M through to S.
At the moment, I can only get it to put a value in column M. If I try to get it to put values in columns M and N, I get a type mismatch error.
Here's the version that...Leave a comment:
-
OMG - it worked!!!!!!
MikeTheBike thankyouthankyo uthankyou, I am SO grateful :-)Leave a comment:
-
Novice Excel VBA coder - type mismatch error
Hi,
I'm a total beginner to VBA, so please bear with me if I seem a bit dense.
What I'm Trying to Achieve
I'm trying to write a procedure in Excel, which is supposed to
- look at the pH values stored in column E, row by row
- compare this to a threshold value of 5
- enter a string ("pH range C") in column K, if the value in column E exceeds 5.
The Proble...
No activity results to display
Leave a comment: