Recent content by eHanSolo

no :(

hi there, Is the following possible: Currently writing some code in UserForm1 and i want to call a public sub from ModuleX. Is this possible? thanks.

thanks for that skip. I'm trying to activate a button (have that black dot on it) regardless of what other button is currently selected. I can call the macro which i've assigned to the button but i can't get that black dot (as if someone physically clicked on it) to appear. Does this make it...

hi there, i have about 3 radio buttons embedded in a work sheet in excel. is it possible to find out which radiobutton is currently active? and is it possible to change its value? I know how to do this if the radio buttons were in a form but i have no idea how it works when embedded in a...

I've sorted it out. Had to hard code the range and use it as a string value as part of a formula inserted via code. Works fine. thanks all the same! e

Hi, Tried this already, doesn't seem to work :( e

hi there, I have a formula (custom function) which uses a named range value that changes every time i select a radio button. Now, how can i get my formula/custom function to rerun every time one of the arguments change without having to click on the cell, press F2 and then return. (even...

Great! i'll give it a go. thanks for your help there! best e

hi there, I have a chart that has a number of text boxes and arrows already on it. the data gets updated from time to time and it's an absolute pain to re-position everything (cuz everything gets shifted out of place). Is there a way to find out the position of the chart, the line, and the...

Hi all, I've got a chart where i've placed a few text boxes and arrows and have then grouped it which is fine. It's really problematic whenever i update my chart. As you can imagine, my chart 'shifts' along when new data is added but the arrows and text boxes are now in the wrong places...

hi there, I've got a piece of code in excel where it copies and pastes tables from different word docs in to a single word doc. I have a reference to the Word object lib. I get to about half way and my code just stops working. the large single doc disappears when i'm debugging. I reckon...

oh found it... good ol' help. thanks! i'll look in to it now.

exactly! nothing is returned for correctVal. pretty sure all my syntaxes are correct. really is 'eating' me up this one. grrr.

what's 'sendkeys'???

hi there, i'm trying to get a single figure from a website. I've gone about it by loading the page in Excel which is fine but i want to fully automate this process but can't due to a login prompt. I have the username and password saved so all that's required is for the 'OK' button to be...