Search:
Type: Posts; User: strobinson1
Search:
Search took 0.03 seconds.
-
Ok, so I've fixed it. By fudging it. It seems to have something to do with the list box being inside a frame. When I was clicking on the list box it seemed loop through the _change code twice,...
-
Only code under _Change and _DblClick, neither of which are triggered when you click on it. Code beneath both only changes the caption on a label...
-
See the attached image. If you arrange your data as shown and use a scatter chart you should be able to draw something similar. With the data, note that you have to plot each point on the line to...
-
Hi,
I've a bit of an unusual bug that is a bit a nuisance. Hopefully this will make sense:
I've got a list box in a form. Alongside it I have a number of other controls that allow me to...
-
Got it to work now. Very minor changes. Still needed the visible tweak in there to make the whole window appear. Job done. Cheers!
Dim w As InternetExplorer
For Each w...
-
I'm working with Excel 2003 and IE 8. Might be behaving differently if you are using a later Excel/IE ?
Could there be a better way for me find the open IE object and navigate through the tabs? ...
-
:check:Ok, should be a quick one. I'm struggling to do something that should be obvious. Must be a lack of cafeine or something. Anyway, any help greatly appreciated!
Below is some simple code...
-
Hi Rocker,
I work in a terminal server environment which means I don't have access to the C:\ so I couldn't access the exe direct. I found the solution now:
Need to add the Adobe Acrobat 10...
-
I've had this happen to me before on workbooks that have very long formulas and many of them, across various sheets. I think it sometimes gets screwed up trying to recalculate them in the right...
-
yeah that's true. In fact should probably just do this and drop the "select" parts that are not needed altogether
ActiveSheet.Rows(lFilaIntercambio - 1).Copy...
-
try this:
ActiveSheet.Rows(lFilaIntercambio - 1).Select
Selection.Copy
ActiveSheet.Rows(lFilaIntercambio).Select
ActiveSheet.Rows(lFilaIntercambio).PasteSpecial xlAll
-
I'm sure there is something very simple I'm missing. Can anyone see it?
Trying to open Adobe reader from Excel. Both "set..." statements produce the error message "ActiveX component can't create...
-
Yes. I found I was getting this problem when moving to a different computer with a different resolution.
I'd open my remote desktop on one computer and open my Excel sheet. Then, without...
-
yes, that would work. Although my actual sheet has lots of controls on it and other stuff that I didn't really want to have to copy over.
And, plus that sheet is REALLY annoying me that I can't...
-
Ok, so I didn't think I'd be coming back to this thread....
think of it as a challenge....
The sheet is completely empty. I have even tried the ExcelDiet Macro (it is in the sheet already). ...
-
lol.
There's also two other commandbars I had to add for when you have a data query behind the sheet. called "Query" and "Query Layout".
-
yeah, found it !
Problem was it was called "Cell" aswell !
so had to do this:
Set cBut2 = Application.CommandBars.FindControl(ID:=1588).Parent.Controls.Add(temporary:=True)
-
Hi,
I have written the code below to put an additional option on the right-click menu of Excel.
However, if the spreadsheet is in the "Page Break" preview, it doesn't appear.
Any ideas how...
-
bingo!
wow, that was a lot simpler than I thought it would be !
CHEERS
-
ah! no, not quite. see the attached image.
If I know the sheet name is "Raw Data", can I find out that is referenced as Sheet13 ?
-
Doesn't that just give me the sheet filename and path?
-
Hi Steve,
Thanks, however I am trying to do something more complex than that. I have an image on the sheet that I want to assign to a macro.
Using the above, if I had a macro on the "Raw Data"...
-
Hi,
Is there any code in VBA that I can use to find out the VBA name of a worksheet?
As in, if you look at the VBA window, in the Project Tree on the left hand side, you can see all of your...
-
"InstrRev(Str1, Str2) checks backward from right-to-left.
That does not mean counting from right-to-left."
aah, now it makes sense ! CHeers ! :)
-
Am I missing something...
Code below...
Both give the answer 5 ! Surely the first one should be telling me 1 ?
Sub test()
Debug.Print InStrRev("simon", "n")
-
CHeers Koolsid!
Worked a treat.
SR
-
Hi,
With the worksheet_Change procedure... is it possible to determine if a cell was selected using the arrow keys on the keyboard or the mouse?
ie I only want it to run the macro if it was...
-
2003. I work through a remote connection to a server that all my company works off so I don't know if that has anything to do with it or not compared to a standalone version
-
Has anyone experienced their buttons on an excel sheet shrinking when you click on them ?
It happens to me sometimes. Or the text inside the control (eg a combobox) gets bigger each time I use...
-
Just found a flaw in this method...
Everytime you then use screenupdating = true, or change worksheet even, it resets !
-
Thanks guys, that works a treat. I am a big novice when it comes to API's. Look like a huge untapped resource I should look into !
-
Is it possible to change/remove the Microsoft Excel text from the top of the Excel window...where it appears along side the workbook name ?
If so.... can you show me how?!??
-
yeah ok. didn't think it was going to be possible ! Cheers for the responses !
-
Hi,
Is it possible, instead of doing:
range("A10").FormulaArrary = "=product(A1:A9+1)-1"
and the result being put into the cell A10...
I want to put the result directly into a variable...
-
yep.
that's what I managed to do !
Cheers :)
Simon
-
Hi,
I want to write some VBA code to Loop through all the entries in a combobox that is embedded in a sheet, and run a different sub each time.
ie
for i = 0 to 10...
-
I have written a macro of 20 loops within loops. Tested in on a number that I knew would definitely be a combination of the other numbers and it does find it....eventually.
Then ran it on the...
-
Sure... see the attached...
the numbers on the left are the originals. the ones on the right are the group totals. I need to work out what combination of numbers from the left will split into...
-
Hi,
Any ideas on how to find out the answer to this easily, greatly appreciated... !
I have a list of 20 different numbers. Last week I split them into two groups (not necessarily in half)....
-
ok, so that should have been obvious. Clearly a Friday!
Cheers,
|
Click Here to Expand Forum to Full Width
|