Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a formula with ListBox toa othes Sheet
Hi, if some body can help me I would appreciate:
what I want to do is to put a formula in running I fill the ListBox Uno from Sheet1 and then once is selected the information from ListBox Uno I want to put create a formula and put that in other Sheet2 If IsNumeric(Uno.List(i, 3)) Then Worksheets("Sheet2").Cells(iRow, 5).Formula = "=(Uno.List(i, 3)*FacInd!$E47 * FacInd!$E93)" So once I run the result is #NAME and is because the Uno.List(I,3) was in run time, I have tryed to return the value from the Uno.List to the Sheet1 ,but then did not work, If some body can Help me Thank you Alberto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm trying to create a formula for an answer sheet. | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
Create a Formula to display the sheet name. | Excel Worksheet Functions | |||
Dynamically create a formula in Sheet B referencing SheetA | Excel Programming | |||
how do you add-u cells value the othes is based another celll be | Excel Programming |