textbox

Hi everyone! I hope you are well. Is there a way to append text from a TextBox on a UserForm to a cell without losing the cell text formatting? Please see sample workbook attached :) TextBoxSample

I am trying to have the ComboBox1 selection determine the row that the value from TextBox3 will be placed, as well as have TextBox2 determine the column that it will go in. The below code achieves the row that it will be placed, however, I can't seem to get the column to work correctly. This...

This is too specific for me to find any relevant info on the internet, at least from my searches, and I'm wondering if anyone can help out. I've created a userform that is filled in by user. I would then like to use the values entered in the textboxes in this userform to populate a new lastrow...

When i double click the listbox, the data shown in textbox is not sorted well (Refer Image). Based on the image 1st image, textbox 1 should be blank , only textbox 2 is populated And for Image 2, it should doing the same things whereby Textbox 2 should be blank, only textbox 1 is populated...

I have two textboxes (TextBox1, TextBox2) that need to be disabled based on combobox1. I need the textbox to be "gray out" to show they are disabled ?How can i do it ? Private Sub ComboBox1_Change() If ComboBox1.Value = "Section" Then TextBox1.Enabled = True TextBox2.Enabled = False End If End...

I have text string in a cell on tab A. For example, let's say it is: "The red dog was very big." I would like to populate a textbox on tab B with the string including the formatting of the string (the bold and color included). In my case a person would select a cell and click a button to...

I have this userform that has a listbox. I haven't been able to get the listbox to populate the values. The Values start on row 3, Column A has the criteria, the sheet name is "MAIN", It populates when the userform is called, but not when an option button is clicked, which adds text to a...

I have a userform that i need a listbox filled with 2 columns from another sheet based on the contents of a Textbox in the userform I have the Textbox populated, and can fill the listbox column 1 I then need to populate 2 other textboxes based on the selection made in the listbox TextBox1 holds...

I am wondering how I would go about adding a button to a userform that could add and remove a portion of text to the left side of a textbox. Simple example would be a button labeled 'ATTENTION' that when clicked would add the following text to the left of a notebox: "**ATTENTION**" Clicking...

I have a checkbox on a userform and I would like for it to add text to a text box, without replacing the contents if there already is something in the textbox. I would like for it to be added to the left most of the textbox, essentially being the first text that is viewed when reading the...

I create a userform that have 80 textboxes in it and all the value I put its unique. I want to fill 80 unique data in the textbox, but I the value should not be the same in all the textboxes and avoid duplicate after update from sheet data.

Hello All, I hope everyone is keeping healthy & happy! Just a quick question. I have a userform that contains four textboxes; 1x start date, 1x end date, 1x Alternate Day number & 1x result. A user enters a starting and ending date, eg "01/oct/2020" and an end date "04/jan/2021". In the...

Hey everyone. Hope you're all doing well. I have a listObject table with 20k+ rows that I'm filtering with a textbox. This is the code I modified a little from extendoffice: Private Sub TextBox1_Change() 'Update by Extendoffice 2018/08/22 Dim xStr, xName As String Dim xWS As Worksheet Dim xRg...

Hi, I have a sheet called "CLP", there are several activex textboxes in this sheet. I want to use VBA to transfer the values of each textbox into a specific named range on a table ("Data") that's on sheet "CLP Client Data" So for example on sheet "CLP" there is a textbox named "TBDate", i want...

Hi all, I have a problem with textboxes in userform. Basically i just want to display one cell with a timer inside through one textbox in my userform. In C2 i have a timer and the cell format is "mm:ss", so the textbox2 should display that cell in that format but it seems so complicate. If the...

I am using below code in my userform in order to put todays date by default. The below code sets the date in the given format in my textbox :- Private Sub UserForm_Initialize() txt_date.Value = Format(Date, "d/m/yyyy") End Sub But when I click Add data, then in the sheet1 the Date column is...

Hi everyone. I have a userform with a textbox and a listbox. The listbox is populated with data from a 2-column ListObject table whenever the form initializes and, as I type in the textbox, it gets filtered using the full string. That works, but since I'm filtering construction materials, I...

Hi, I have a userform that fills a table with the values from the boxes but sometimes the output in the table is in the form of text and not number. Ive tried many solutions but none seem to work... Bellow is the code for filling the table in case is needed. When the MontanteBox, EURBox...

Hi there, I'm rying to set a condition on a user form so that the user needs to close a textbox before the open another. The textbox is opened via a command button. I have never used the "OR" function before so had a look online. The code I have just opens up the msgbox regardless f whether or...

Hi there, I have a textbox (TBPsychology8) which is populated using the code below. I also want this box to be visible or invisible (depending on certain criteria) when you click a command button (CBDisc8). The criteria are: -If TBPsychology8 is blank and invisible then run the code to populate...