label1

On a userform i have these Function's Combobox1 Labels 1 to 7 Textbox 1 to 10 and Commanbutton 1 to 7 I need the Combobox to Look on Range from Cell ("A1:A127") i get it to work on these Codeline Private Sub UserForm_Initialize()'add column of data from spreadsheet to your userform ComboBox...

=num1/GCD(num1,num2)&":"&num2/GCD(num1,num2) This formula is a ratio between two numbers. Is there a way to do this in vba? I have 3 labels (Label1 , Label2 , Label3) in a userform. Label1 & Label2 will have the numbers and I would like to output the ratio value to Label3. Can anyone assist...

Hi, My latest question, to me, seems much simpler that what i have previously asked, but i cannot get through it without label not defined errors, endif without this that and the other errors I need a short piece of code that if the result of a particular cell (AA99) on Sheet33 is 1000001 then...

[/URL][/IMG] Label1 is the white box down and right i need to put in Label1 ,value of range("Q3") tried ...Label1.Caption = Sheets("WORK").Range("Q3") but it keeps sleeping Please help,thanks for your time

Hola buen día, No se mucho de excel vba, lo que he hecho es en base a tutoriales. Necesito ayuda por favor con un código que llevo días tratando de resolver y no puedo. Tengo mas código hecho pero esta es la parte donde tengo problemas, en el renglon en Negritas y subrayado es donde me aparece...

if user click on command button,user form will pop up I have made a Userform1,i have added label to it I want to find user windows name on label1 Can i get macro for it?

i have one user form,it have Label1 I want to link my Label1 with "user administrator name" i mean "windows user name" can we get it automatically when userform pop up

Hi, I have used the following code to take a value from cell "A10" in "Sheet1" to reflect in "Label1" on my userform. The code is working; code: Label1.Caption = Sheets("Sheet1").Range("A10") I have formated Cell "A10" on "Sheet1" to South African Rand value. The value in cell "A10" is "R40...