ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create a formula with ListBox toa othes Sheet (https://www.excelbanter.com/excel-programming/349671-how-create-formula-listbox-toa-othes-sheet.html)

Alberto

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


All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com