I've been searching a lot, but couldn't find anything about what I would imagine to be pretty easy.
I'm trying to get a number out of a List, that is getting information out of an Excel file. But I don't think that matters.
I then want to give it a percentage, but it doesn't want to see the list as a value.
So I figured I would put the List Value into a Text Value, to then calculate it.
Private Sub cmdBereken_Click()
Text1.AddItem (lstPrijs.Text)
prijs = Val(Text1.Text)
percent = 1 + Val(Text2.Text) / 100
eind = prijs * percent
Text3.Text = eind
Text2 = ""
End Sub
Can anyone help me with this?
Thanks in advance,
Q~