Search results for query: *

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.

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...

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...

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...

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...

hi there, trying to use the following but for some darn reason it's not working. I get no error messages and the stepping into it does nothing. Any ideas? set myRng = Worksheets("Monthly").Range("A1:B10000") correctVal =...

hi there, I've seen people enter the following. Can anyone tell me why they add the '+' bit?? I can't seem to figure out the significance of this. so a cell would contain something like: =+A1 thanks for looking/helping! e

Hi there, Can anyone help with the following: I want to be able to open an excel workbook with out any user intervention. So i've scheduled a task to open myWorkBook.xls. In here i've put in a sub workbook_open() which it will call other bits and pieces and then close down the workbook when...

hi all, i've a table with 4 rows and 2 columns. In each of the rows or 'cells'(1st column), there is a number: 1.1, 1.2, 1.3 and 1.4 I'd like to do a search for say '1.2' and then copy the entire row and paste it in to a separate word document. So i could end up with two word documents; one...

hi there, i'd like to separate the contents of a big word document in to smaller word documents depending on the table contents. For example, each table cell has a unique number like 1.2.1 I'm quite familiar with excel vba but i'm not quite sure how to tackle this one... any hints, tips and...

hi there, was wondering if it's possible to apply formatting like bold, font colour, font size when i'm concatenating a few strings together?? thanks! e

hi there, i have a date in cell A1 showing: May-06 I'd like to have a few buttons that would increase the date in this cell either by one month at a time or 6 months at a time... any ideas?? (hope you all had a great weekend!) thanks! e

hi there, i'm writing a function where it takes a named range as an argument. With this range it has a number of values and i've managed to get the smallest value (which is what i want by using this: myVal = application.worksheetfunction.small(myNamedRng,1) so far so good. What i then want...

hi there, I have a named range of which i'd like to get the row part of the adress of the first and last value of the range (the range is quite large and only a portion of that range has values in it).... can someone point me in the right direction in doing this in VBA please?? many many...

hi there, I have a named range of which i'd like to get the row part of the adress of the first and last value of the range (the range is quite large and only a portion of that range has values in it).... can someone point me in the right direction in doing this in VBA please?? many many...

hi all, I'd like to send an email, maybe from excel with a macro attached to a button that would automatically send an email once a few fields have been filled in. is this possible at all?? ...any help would be greatly appreciated. thanks. e

hi all, seeing i can't change the log scale to a log chart done in excel... can anyone suggest any good logarithmic XY chart packages out there? something cheap and cheerful? thanks, E

hi all, was wondering if it was possible for a worksheet formula to take in a variable specified by a cell. for example: range(A1).value would contain something like: 'MyFile.xls' then i'll have a formula like: =sum('networkpath here' & range(A1)) possible?? e