Search results for query: *

I'm unsure which is the most appropriate forum for this question so thave opted for the here I have a formula... S * [a ^n(1-X)] * [b ^nX] = S Can someone help me with the steps to get X = ? I have given this a few tries and can get to a^n = b^(-nX) - a^(-nX) but am struggling to get any...

I have a formula in excel which works out a compound interest X = P*(1+R)^N or as excel formula =B3*(1+B4)^B5 Where P = starting amount, eg 1000.00 R = rate, eg 0.12 N = number of iterations, eg 20.00 In the example above the answer is 9646.29 rounded to 2dp What I need is to introduce a...

I have a grid in excel which I want to write to based on 20 different possible filtered variations on a set of data contained in an array. This grid will be used to populate excel charts I've set up an array of arrays using Private Type OsArray write_array() As Variant End Type Dim...

I have an excel app I'm developing which fetches some data from a database over a network using SQL. This works fine and returns a recordset which I've passed into an array for calcs. The intention is to also use this returned recordset to populate a set of comboboxes based on other combobox...

Can anyone replicate this weird behaviour and offer a possible workaround? I have a combobox which I want to resize back to normal on a change event. The change event fires and the code runs but the combobox doesn't resize when running live. If I step through using a break then resize does...

I have a range in excel which gets loaded into an array, I then perform calculations on the array and write it back to the same range. I would like to be able to colour the cells say blue if the new cell value is less than previous and red if greater than previous value. The only way I can...

I am writing some values to cells in excel via VBA which are to 2 decimal places. I want to flag some of these to identify they have been calculated. The way I thought I could do this was to add a small number to the end Eg. Standard value = 23.08 Calculated value = 23.08000001 Then use...

I have a 2 dimensional array - write_array(1 to 23, 1 to 7) When populated slice write_array(2,x) typically look something like this with variation of times and Empty entries write_array(2,1) = "TIME" write_array(2,2) = 23.08 write_array(2,3) = 22.58 write_array(2,4) = 23.02 write_array(2,5) =...

Is there a way to put a PC installed with XP or Windows 7 into hibernation and bring it out again at designated times using VBA within Excel?

I have some code which requires reference to the Microsoft ActiveX Data Objects x.x Library; The one I am using is the'Microsoft ActiveX Data Objects 2.8 Library' Eventually this code may be used by other people. Is there a way to programatically load the required reference in VBA? Thanks, Os

I've just imported 2 excel tables into Access 2007 Table 'RP Data' contains 102,653 records, 'BFSP Data' contains 226,482 I want to return ALL records in 'RP Data' table regardless if there is a match in the other. I assumed this would work SELECT [RP Data].*, [BFSP Data].BSP, [BFSP...

An extract of my code below works fine if column EV is visible. However, I have this grouped together with other columns to hide these columns from the user. The problem is the code below then returns nothing when the column is grouped and hidden I could unhide the column as part of the code...

The following code works for 1 worksheet. If I had multiple worksheets that are all updating independently from a 3rd party app. What's the correct syntax to fire multiple events and ensure the range updates on the required worksheet? Private Sub Worksheet_Change(ByVal Target As Range)...

I have some code which calls a function to retrieve a webpage source as a string call Private Sub Worksheet_Change(ByVal Target As Range) If raceURL2 <> "" Then liveshowoutput = ExecuteWebRequest(raceURL2) resultArray = Split(liveshowoutput, "HORSE_NAME -->") End Sub...

In my excel visual basic editor the locals and watch windows won't appear when selecting them in the view menu - only seems to have happened today. I've minimized all other windows to see if they're hiding behind but they're just not there. Has anyone got any suggestions?

Not sure if this is possible but would appreciate a quicker way of implemented the attached. I have quite a complex excel input sheet which with many fields containing formulas to make it interactive. The formulas will be overtyped with data. The input sheet will be lightly password protected...

In excel I have a combobox from the control toolbox menu named 'H1_1' I have an event which runs from Private Sub H1_1_gotfocus() What is the correct syntax to capture the object name? Eg this doesn't work Private Sub H1_1_gotfocus() MsgBox (screen.ActiveControl.Name) end sub thank you os

I have some vba code which I only ever need to run once when an excel workbook opens to extract URL's into an array. I have placed it in the 'ThisWorkbook' object using the event Private Sub Workbook_Open() The format of the array is Array(i,0) URL Array(i,1) Weekday Array(i,2) Venue Array(i,3)...

I'm trying to create an array with 4 dimensions to read in a combination of 4 non-contigous ranges. However, the attached only creates a 2 dimension array Please can someone advise how to create a 4 dim array? Essentially I want to pass in 3 ranges, make a calculation and pass result into the...

I have some vba code in excel which runs on the Worksheet_Change event after an update to the worksheet every 200ms The refresh rate after running existing code averages approx 210ms however when I add this code to compare two ranges the average refresh rate inreases to approx 400ms What is...