label1

  1. H

    userform with many Modes..

    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...
  2. A

    Calculate a ratio from two numbers in vba

    =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...
  3. m_in_spain

    if then and go to

    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...
  4. P

    Show value of a cell on a Userform.label

    [/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
  5. A

    TextBox con error Object doesn´t support this property or method

    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...
  6. B

    Find user windows name

    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?
  7. B

    label control

    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
  8. K

    To reflect a Currency (Rand) in a lable ona user form.

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top