textbox

  1. P

    Copy cell value from a different workbook into a textbox in a userform

    Hi, good afternoon, I have a userform with TextBox310 where I want the textbox to show the info from another workbook for example the work book is located in 'G:INDAY.xlsm ' and the info is in sheet1 cell S17, please can you help? I have tried... [CODE]Private Sub TextBox310_Change() Dim WB as...
  2. J

    Finding Date in Listview

    Hi, Is there anyone that can show me how to find in listview control column 2 the earliest date and populate it in textbox 1, and the latest date into textbox 2. Thank you to anyone that can help me.
  3. Z

    VBA code to search Column and enter text box value in the line below

    I have a userform that the user will pick from the combo box list and then enter in a value in a textbox 1. Once the user clicks the OK command button I would like it to search the combo box value in column A on Sheet1 and place the value from textbox 1 in the next available row below in column...
  4. D

    Get Values in Text Box based on Check box Selection

    Hi All, Need a help on resolving the below scenario. I have a column A with Months and Column B with unique products ID's. Each months are having checkbox and i need based on the check box selection, the text box and excel sheet should be updated with the all the products from that specific...
  5. K

    VBA Userform

    Hi All, With a UserForm TextBox you can limit the number of characters to be used in the TextBox properties MaxLength behavior. I want to know if your set the MultiLine to True, can you limit the number of lines that the user can enter. For example I have a UserForm with a TextBox. I want the...
  6. T

    Can I run a macro after i've pasted?

    Hi Everyone I'm having a few problems with people wanting to copy data from word and paste into a single cell in excel as excel wont do this the way they want to so i've created a textbox for them to paste into. but what i need is for a macro called "Tide_up" to run after they have pasted is...
  7. T

    Macro to adjust a textbox to the size of the text

    Hi Everyone, I've been playing around with activex text boxes and have found I can adjust the height as I type. so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in I have this bit of code that will resize the text box so I...
  8. M

    Populate textbox dependent on combobox value

    Hi There, I have no idea where to start with this so would love some help. I have four comboboxes with twelve colours on the list (each has an identical list). Say the colour "Red" is selected in the combobox i want the textbox to populate with information which corresponds to the Value "Red"...
  9. P

    How to autopopulate a textbox linked to a cell

    Hi hope you can help, I have a userform1 with multiple texboxes in and I want this to automatically load up with informaton from the 'Data' sheet into the textbox, I have done the code below but its not working, nothing appears in textbox1. for Example TextBox1 I want to look in a sheet...
  10. D

    Textbox value to cell in active sheet rather then Specific

    Hey all new here. I am having an issue changing code to place textbox value to current active sheet rather than a specific sheet. I am working my way through to create an active form to generate data based on scanning an item into a single textbox. TextBox1.Font.Size = 28...
  11. D

    Empty textbox needs text

    I have a regular textbox (Shape, not an active x textbox) that needs to have the text "Please type notes here" if it doesn't have anything in it. I also need the text to disappear when you click in it so it is ready to type into. Could someone help me with the vba code please?
  12. D

    For each cntl trigger class module

    Hi I've dynamically created a number of textboxes on a userform. Each textbox was added to a class module with some associated attributes. I also have a number of option buttons to the side of the userform. By clicking the textbox, i can update the text in the textbox from the asociated...
  13. S

    TextBox Exit Event

    Hello Everyone, Have used this site many times as resource for my excel vba needs. Was hoping an individual could with a specific problem involving Win10. I have developed a userform to assist in a rework process. Intended result is user to enter a serial number using a textbox, if...
  14. E

    Populate userform textbox with date taken from cell in 'dd/MM/yyyy' format

    Hello, I want to fill a userform textbox with a date taken from a cell. The date in the cell is in 'dd/MM/yyyy' but the date drawn from this cell into the textbox comes always as 'MM/dd/yyyy'. Any suggestions would be highly appreciated as I have been wasting tons of hours on that issue...
  15. G

    Help with userform textbox

    Hi everyone, I have a textbox on my userform called "SerialTxt" what i am wanting to do is when a user enters an alphanumeric number with special characters "-" i want that textbox to check cell "P1" on a worksheet called "Data". If the value is the same then allow the user to continue, if the...
  16. kelly mort

    Update image file name based on textbox content

    When I enter the textbox, I want to store its content to a variable "MyEnter". Then when I change the content I store the changed content to " MyChange". Then inside a folder , "MyPics", located at the location of the workbook, if there is an image file called same as the content of the "...
  17. S

    Change of TextBox Value

    Hello Everyone, I'm working on a simple GUI to input serial numbers. I have created a textbox in a userform to allow a input of a serial number using a hand scanner. The scanner will read serial number and submit an Enter command upon completion of input. Using the Enter command allows the...
  18. T

    VBA to resize a range to fit the textbox.

    Hi Everyone, I have a problem, I need people to be able to copy and paste text from Word into excel, I have encounted a number of problems doing this as the people doing the cut and pasting are all at the lower end of the gene pool. So after many hours of testing the only solution I could find...
  19. G

    Userform textbox to fill into cell

    Hey all, feeling very dumb here. I'm trying to make a simple userform with one textbox, and when the user hits the "Retire" button it will input the data from the textbox into a specific cell (B14 in my case). This feels very simple and I've done it before, but for some reason I can't get it to...
  20. D

    VBA add new sheet to End of Workbook

    Hi all, I have a question Here is the code to add a new sheet having the name of a textbox.value from a userform Sheets.Add After:=Sheets(Sheets.Count) Sheets.Add.Name = textbox.value I would like to know why when the code is activated, the macro creates 2 sheets, the 1st rename with the...

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