hel wit user form with functions

**JIGACE** · 08-16-2012, 12:50 PM

Help please, i been tryng to do a userform that calculate a result with the data captured in and a matrix in a separated sheet. im using:

Please Login or Register  to view this content.

Can anybody help me?
data.png

**royUK** · 08-16-2012, 12:53 PM

It should be Application.WorksheetFunction.

Look at the VBA Find method.

**JIGACE** · 08-16-2012, 01:01 PM

Originally Posted by royUK

It should be Application.WorksheetFunction.

Look at the VBA Find method.

Sorry, I dont understand the find method. My excel is 2007, and i am Very new at this, im learning and very proud of the simplest things i accomplished. Could you help me? I Know once i see the propper method i can learn to do other things to.

Here's my work so far. In the index sheet is the first userform, then "captura" triggers the one i have difficulties with.

And yes, my english is very poor, sorry about that.

**royUK** · 08-17-2012, 02:38 AM

You cannot write to the body of a Frame so I would have though a TextBox within the Frame would be better.

This will find the value entered into TextBox1 & write the value fromthe data in Column D

An alternative approach would be to use a CombBox loaded with the values from Column A of the data, this would allow the user to only pick correct values. The required entry would be entered based on the CombBox's listIndes Property.