# ComboBox: Equation In A Column Of Cells

Nov 12, 2008
I want to do is a simple list, 2 items, call them "Thing_1" and "Thing_2". I have an equation in a column of cells. The equation is a simple If statement. If the user selects "Thing_1" then the first equation will run, and if "Thing_2" is selected then the second equation will be used. That's it. No more complex than that.

My original questions about how to initialize a ComboBox are cross-posted here: http://www.excelforum.com/excel-prog...ml#post1996135

View 4 Replies
ADVERTISEMENT
Mar 20, 2007

i am plotting graphs which i need the equation of the line from. i have been manually typing the x^3, X^2, X^1 and X^0 values into 4 cells which is then used elsewhere, but wanted to know if its possible to get some code to do that for me?

View 2 Replies
View Related
Nov 21, 2006

How I can refer to sheet...Without activating sheet. i have this

Private Sub carga_click()

Sheets("Codigos de Area").Select

Sheets("Codigos de Area"). Cells(1, 2).Select

While ActiveCell <> ""

ActiveCell.Offset(1, 0).Select

ComboBox1.AddItem ActiveCell

Wend

End Sub

View 2 Replies
View Related
Jul 30, 2014

Any way I can get an equation to only apply to cells with information in? E.g. I have two columns, one with 'disposal dates' in and the other with 'extended disposal dates'. I would like to get the difference between them (Extended disposal dates- disposal dates) however not all of them have an extended disposal date, therefore some cells display as '#VALUE!' because its calculating the disposal date-blank cell....

View 3 Replies
View Related
Jan 29, 2013

I need to have a single combobox pull values from a very large term list (>40,000), and place selections in a single column in sequential cells (eg, B1, B2, B3, etc..). With the following code (credit to Ingolf and MickG) I am able to get the list to popluate cells in a column. However, I cannot seem to find the proper attributes to control the auto selection of items in list. I do want the autocomplete feature so the user can quickly navigate this huge list, but as soon as i start typing, it starts populating terms into the growing list. I would like to have the user actually select the item.

Private Sub Worksheet_Activate()

Dim Rng As Range

With Sheets("Listing")

[Code].....

View 1 Replies
View Related
Mar 23, 2007

I have the data sheet, which is the result of another function. It produces 10 columns with numbers in each cell, there can be any number of rows, but the key is that the rows are outlined as follows. The first row has the first column number bolded, followed by the second row not bolded and then a space and a repeat of the bold cell, followed by the non bold cell. Each row fills up all ten columns. I have attached an example of the sheet.

What I would like to do is create a function which says brings up a box that says "Input Row" and the user would input the bolded number of a row. From here the code would take that value entered and divide it by the inputted bolded number’s adjacent cell, to the right, aka B2 column. This value would then be multiplied by every other bolded rows second cell, B2 column, essentially giving rise to a normalization of that column. The output would then be displayed in a new column, column 11 in italics. Each row would now have its italics value corresponding to the bolded number’s row and not the other rows.

View 7 Replies
View Related
Feb 6, 2009

im trying to implement the equation bellow in one cell so that i can then copy paste to about 300 cells.

A= 0

A= A + {IF(B279 = B(i), C(i), 0)}

= ‡”i= 6 B(i) & ‡”i= 6 C(i)

........i= 274 .............i= 274

View 9 Replies
View Related
Sep 12, 2013

Is there a way of copying an entire sheet, but pasting only the cells that don't contain an equation?

I have a number of populated templates that need to be copied into a master document, both formatted and laid out the same. However, I have some instances where the templates have been fiddled around with so the formulas have been corrupted. So, I'd like to pick up the raw data without the corrupted equations.

View 3 Replies
View Related
Jun 9, 2006

I have a userform where I have 2 comboboxes. The first combobox shows the the first column (only 1 of each) and the second comboBox shows me the secondary list that correlates to the valuse in the first from column B. Now I have a text box that I am trying to get the value from column C depending on what I have in the first 2 comboboxes. What is the easiest way to do it? This is all in VB since it is a UserForm, and using Vlookup seems to be too many lines if I go that route. Is there a way to use Index and Match in VB where it would be more efficient? I attached just a sample of how the data would be layed out in the Excel sheet.

View 4 Replies
View Related
May 9, 2006

How do I get to see the equation behind Excel Functions? For instance, the

result of pmt() is not making sense to me, I'd like to see what this function

is doing and how it is calculating its value. Trial and Error is rather

time-consuming and tedious.

View 13 Replies
View Related
Oct 9, 2009

It looks like this (log(X/Y))/log2. The X and Y are celldirections (E2 or F4 and so on). How do i setup that formula in excell?

View 2 Replies
View Related
Jul 24, 2012

Can I use excel to get make an equation for 4 variables (x,y,z,w)

E.g.

a,b,c,d,3,f,g,h,i, would be constants

w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz

I tried regression but the equation looks like

w = ax + by + cz + c

Is it possible on ay other software e.g MATLAB

View 9 Replies
View Related
Oct 18, 2007

I have the following formula.

=SUMIF(hfx!A:A,"123456789",hfx!J:J)

very simple.

for the totals in J, if there is a (-) negative number, i would like that excluided from the equation.

View 9 Replies
View Related
Oct 22, 2008

Lets say I write an equation on my sheet such as:

='A1'!$H422*AH$138

but instead of hard coding the A1 sheet name, I want that to be a value that I can put in a different cell (lets say cell C1) on my same sheet in such a way that it will reference the value in my other cell (Cell C1) and put its value into that equation.

So if I make the value in C1 = A99 then the equation becomes

='A99'!$H422*AH$138

View 9 Replies
View Related
Dec 1, 2006

I am trying to populate a combo box with two columns of data read from two consecutive (or non consecutive) columns of data. The following code is what I have come up with after visiting several of the previous threads on similar topics (couldn't find one that gave a general, concise solution).

Private Sub UserForm_Initialize()

Dim lngRow As Long

Dim lngRowtot As Integer

Parameters1.SG1.Clear 'Clear combobox SG1 in userform named Parameters1

'Find the number of rows required for the array and combo box

lngRow = 12 'Start searching on row 12

Do While Sheets("Timber Properties").Range("H" & lngRow).Value <> "" 'Read until empty col H lngRowtot = lngRow - 11

lngRow = lngRow + 1

Loop

Dim MyArray(1 To lngRowtot, 1 To lngRowtot) As String 'I get an error with the last ingRowtot on this line.....................

View 2 Replies
View Related
Nov 20, 2008

Below is a nonlinear model, together with calibration data for which I would like to find the parameters Ro, Kc, a and b.

R = Ro + Kc * (1/(1 + exp(-(a + b*lnC))

Calibration Data

C R

0.00.3347

4.80.4201

7.70.5141

11.20.6177

14.40.6887

Given the calibration data above, how can I calculate or at least estimate these parameters?

I do not want to use an add-in program, like Solver, in Excel. I do, however, want to be able to use any existing functions, if necessary, in Excel. i'd appreciate it if someone can walk me through the steps.

View 9 Replies
View Related
Jan 13, 2009

The equation is basically: 10^[A/20]+10^[B/20]+10^[C/20]. Now imagine that there is no input value for C. I need to make it so that it won't add the bit I've highlighted in green.

View 5 Replies
View Related
May 13, 2009

I will like to ask, if there is a way to get in a cell the result of a simple equation without having to copy the contents of that cell with a = in front for example if i have in one cell

15*2+35*4+30/2

in the next cell to display the result

185

View 11 Replies
View Related
Mar 1, 2007

I need to take a number, multiply it by a precentage, & then round it to the nearest multiple of 5.

ex:

A1=142.5

B2=A1*50%,(then rounded to nearest multiple of 5)

View 9 Replies
View Related
Aug 6, 2012

if i obtain an eqn by plotting a graph in excel, etc,

y = 1.22952117E-06x3 - 1.08197863E-05x2 + 9.97531712E-01x + 3.99014495E-01

and i wish to subsitube a cell value from another sheet into the 'x' in the above eqn and i need to do this 20 times.

View 3 Replies
View Related
Mar 18, 2013

I need to move a value to another field (with equation) and use the output for the same equation till limit is reached..

View 2 Replies
View Related
Jan 11, 2014

How to add an equation to a drop down selection if you take a look at the picture in the link supplied, what I want to do is: I want the calculator to take the number in D12 then if the drop down box under it the selection is (as it is) too high then subtract 50 (k11) from D12 and display the answer in D14. I have listed the 3 drop down choices in column L, Lap 2 I would do exactly the same and so on [URL] .........

View 6 Replies
View Related
May 20, 2007

I have a cell on ' Sheet 2' with the following formula:

=MAX('Sheet1'!C3:'Sheet1'C10)

ie. it chooses the maximum value from column C between rows 3 and 10 on "Sheet 1".

Lets say the cell reference C10 is now entered into cell B1 on Sheet 2. How do I modify the above formula to reference B1?

I have tried INDIRECT function but can't get it to work.

View 5 Replies
View Related
May 16, 2008

I am trying to calculate the equation of a curve which best fits some data. On the x-axis is date and y-axis the readings. The curve is quadratic, so on the chart I am fitting a 2nd order polyomial and displaying the equation. To prove that the equation the trendline gives me is reasonable, I am applying the equation on the x parameter to get the y parameter estimate and looking to see the error between predicted and actual - see attached.

The equation and the output from it are clearly rubbish, even though on the graph the trendline is a reasonable fit - see attached. Has anyone any ideas why? I think it has something to do with using a date on the x-axis but no idea why. Is there a way to correct for this? I also tried using the following I to calculate the coefficients which came up with a reasonable forecast (although linest should only be used for linear data): =LINEST(C3:C15,B3:B15^{1,2,3})

View 2 Replies
View Related
Dec 10, 2009

I have a combobox on a userform that I have set the columncount to 3, so it displays data from columns A, B, and C when the combobox dropdown is used. However, once someone makes a selection from the dropdown, only the item from the first column is displayed in the combobox. Is there a way for me to show the info from all 3 columns once a selection is made?

View 8 Replies
View Related
Sep 3, 2009

I have a userform with comboboxes and listboxes etc. The comboboxes have drop down lists which are populated from data in columns from a worksheet.

1.) During the execution of the userform, a value is selected from the combobox, which is place in a column on another worksheet. So far so good. If I select the same value again, nothing shows up in the row below the first selection. If I choose a different value it shows up. I have tried using different properties of the combobox but have not been able to get around this.

2.) I would like, when the excel file is opened that the userform is ready to go, ie enter data. I have tried putting the

Private Sub Workbook_Open()

UserForm1.Show

End Sub

in "ThisWorkbook" module but have had no success with it.

View 12 Replies
View Related
Jul 2, 2013

I have some vba code that opens up notepad and populates it with data from Access 2010. Everything works great including the notepad function, the database, and how the data is stored and displayed in the table/form.

The problem: I want to display the service name not the ID in notepad

I passed the field that I want to include in notepad as a string. However, it returns the ID and not the name of the person.

I don't want to change anything in the form or field property because it works perfect as is.

Is there a way to pick which column to display in the Email by vba code?

Column 0 = the ID and Column 1 = the name

Code:

Me.fieldName.Column(1)

^^That doesn't work for me

Here's my code (it works)

Code:

Private Sub cmdNoteAccept_Click()

Dim strCode As String

strCode = strCode & Me.Servicer & ": "

strCode = strCode & Format(Me.DateCreated, "MM/DD/YYYY")

strCode = strCode & "Insert message here"

Shell "Notepad.exe", vbNormalFocus

SendKeys strCode, True

End Sub

View 3 Replies
View Related
Jul 25, 2013

I've got a small project to build a small cashflow report... Here is my sheet looks like...

A

B

C

D

E

F

G

H

1

Name

Jan

Feb

Mar

Apr

May

Jun

Jul

2

qwe

10000

20000

[Code] ...........

I've created a userform that looks like this :

I need the amount entered to be inserted based on the name combo box and month picked...

So in a simple words, after i pick "uio" in name combobox and pick "Jul" from month combobox, the amount that i pick from amount combobox will be entered in cell H4...

I've tried several ways to return value and using search function and match the data, but its only for row, not both row and column... Is there any way to achieve this?

View 8 Replies
View Related
Aug 1, 2013

I am trying to use a combo box with a defined list I have in another worksheet.

I was able to name and populate the list into the combo box, but am trying to work a macro into it.

I have a large data sheet with with many columns. In this worksheet, I also placed the combo box. What I would like to do is to be able to click on a name in the combo box and have it filter Column H, where there are many data points.

For example, In column H I have Apples, Watermelons, Peaches, etc.

In the combo box list, I would like to click on Apples and Column H list only the Apple names. Then if I want to click on Watermelons, it would filter Column H to only those which have Watermelons listed...

View 1 Replies
View Related
Jul 11, 2007

I would like to populate a combobox with text from two different ranges:

I have an ID No in column A (range = ID)

and a descripton in Column B (range = Description)

I would like the following to appear in the combobox:

"J.034 Kitchen Bench"

at the moment I can only get J.034 from the following

Private Sub UserForm_Initialize()

Dim cBase As Range

Dim ws As Worksheet

Set ws = Worksheets("Matdata")

For Each cBase In ws.Range("ID")

With Me.cboBase

.AddItem cBase.Value

.List(.ListCount - 1, 1) = cBase.Offset(0, 1).Value

End With

Next cBase

Me.cboBase.SetFocus

HideTitleBar Me

End Sub

View 9 Replies
View Related