Normsinv funciton

  • Thread starter Thread starter Sunil Pradhan
  • Start date Start date
S

Sunil Pradhan

I want to use ms excel function normsinv to calculate some value in vba?

how can i use?
 
Maybe

MyValue = WorksheetFunction.NormSInv(Range("A1").Value)

Mike
 
mike, it did not work. I am giving down the complete code to calcuate some
value.

Private Sub CommandButton1_Click()
Dim val As Single
Dim res As Single
Dim myvalue As Single

val = CSng(TextBox1.Value)

Sheet1.Cells(a1).Value = val

myvalue = WorksheetFunction.NormSInv(Range("A1").Value)

TextBox2.Value = myvalue + 1.5


End Sub

pls help. this runs on form.
 
1. Sheet1.Range("a1").Value = val
2. what value are you inserting into A1? should be >=0 and =<1 according to
Help since this is probability

HIH
 
Hi Jarek,

It worked, but I want some more. I do not want to transfer the value to
cell, instead I want to use withing the code. Pls make me mroe comfortable
doing this.

Sunil


Private Sub CommandButton1_Click()
Dim val As Single
Dim res As Single
Dim myvalue As Single

val = CSng(TextBox1.Value)

Sheet1.Range("a1").Value = val

myvalue = WorksheetFunction.NormSInv(Range("A1").Value)

TextBox2.Value = myvalue + 1.5

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NORMSDIST() and NORMSINV() 3
eliminate negative value from normal random number distribution 4
Need help reversing a formula... 2
Sigma Calculation in Access 3
IS there a mathematical formula for NORMSINV? 1
Calculate a Sigma Quality Level 2
Transposing Excel Formula 2
Attempting to create a function that i can use in a query. 1

Back
Top