1. S

    How to Pick random cells to Userform

    Hi all: I have workbook with sheet(data).range(A1:A1000) as text Now I want macro apper random cell in texbox when Userform.show Please help me to do that, many thanks./.
  2. M

    Expand cell height to match textbox

    How can I get the cells to expand with the size of a texbox. I am entering text and the Activex texbox is expanding with Multiple lines accordingly to the text, but after a period goes over other fields, How can I get the field cells to expand?
  3. R

    TextBox Addition

    Hey all, Using a button to open a Userform. I need the values in TextBox1 and TextBox2 to be 0. I have a TextBox3 and using TextBox3_Change if the letter "A" is typed into TextBox3 I need to keep a running total in TextBox1 (0+1+1+1+1...each time the letter A is typed) and if the letter "B" is...
  4. O

    Textbox Only Returns Zeroes

    Hello, I've been trying to build an userform in which I have several textboxs. In one TextBox I want to insert numbers and letters, in all others I just want numbers. All are returned in a table. I Thought it would be an easy task.... Though I only get zeroes in the table. I don't understand...
  5. T

    Userform TextBox input format problems

    Hi there! I've made an userform with a textbox. I want to force the user to type the value in a specific format, e.g. 5.2.0 The code I have now: If Not TextBox1.Value = Format(TextBox1, "0.0.0") Then GoTo FormatError (rest of the code) FormatError: intresp = MsgBox("Insert valid version...
  6. L

    Setfocus is not working after a looping through the textbox

    I have an "Input data" form and all I'd like to do was to add a code so when the user press the button Ok it'd check each texbox and if it's empty show a error message and setfocus back to the empty textbox.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...