textbox

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

Hi there, In my userform i have several textboxes which are made visible by clicking a command button and then invisible by clicking another command button. When I close the textbox (make invisible) the userform position changes and it scrolls half way up the form. Is there a way to set a...

Hello all, I have a spreadsheet with some checkboxes and text boxes. I would like to write a macro so that when I check a specific checkbox, it automatically enters into a specific textbox. I've found properties such as "enter", "setfocus" but those only seem to apply to form textboxes, I...

Hi there, I'm wanting to copy text from a userform textbox into a workseet textbox i.e. a non activex textbox, just a standard textbox (Activex textboxes are easier but i find that they tend to lag on a worksheet). So the sheet is called "Life Purpose" and the textbox is named "TBSR1", can...

Hi, I was wondering how i would reference a textbox in VBA. I can do this no problem with activex textboxes but don't know how to do with a normal one. I am wanting to use a normal textbox as the activex one is very laggy and takes forever to show the text you're typing. Many thanks for your...

Hi, is there way to stop user from resizing a text box ?? I have this script that brings it back to the pre determined size but is there a way to trigger it every time it is modified. Ideally I would want this to be dynamic where it does that for all textboxes on the sheet ( if not, i...

Hi I have a few tables and a few textboxes next to the tables. I want the textboxes to expand when new rows are added to the table. The range would be dynamic hence I have to find the textbox in the specified range and then adjust the height. I tried to code it but the height of the textbox...

Hello everyone. As the title say, I have multiple (at least 10 I think) cmdbuttons on a userform. I have 2 things I am looking to achieve: 1. Copy the cmdbutton captions to clipboard when clicked. This will be pasted on another program like Notepad, etc. 2. Show the cmdbutton captions on...

Hello All, As the title says (i am not sure if this kind of title is allowed, kinda desperate for help), I have a few queries about my current worksheet. Below is my code for my checkboxes and comboboxes captions to appear on my TextBox3. Shoutout to @DanteAmor for these codes. What I want to...

Hello All, Need help with my work. I have a userform that has multiple checkboxes and a label. What I am looking forward is: 1. I want to copy the label into the textbox when one of the checkbox is selected. If multiple selections, one label only for the entire selection. 2. I want to copy the...

Hello everyone my problem is a little bit annoying. When i try to scan a barcode in the textbox there is always number 7 is missing. for example if the barcode is 123456789 it writes in the text box 12345689 . The barcode scanner works perfect except in the userform. I tried in the notpad it...

Trying to get an Array to work with Formula Countif, but cant manage to get the countif right, can anyone give me a pointer please? I have a userform with 5 textboxes on it add a search word in 1 or maybe 2 i wanted them to use the countif formula. Sorry if this seems simple to you guys im...

Hi, I have 2 scenarios where: 1. I have an integrated VBA form where values are input manually in a textbox and I get results outputted successfully. I was able to find an i.e. =embed((m1r1) command in the textbox but can't seem to access it again. The first sheet has code like this...

I wondering how can i formulate this textbox status to display textboxStatus to blank when combo box is closed and when combobox1 is in "Open" then TextBoxDate.Value - DateNow. if ComboBox1 = "Open" then TextBoxStatus = txtBoxDate.Value - DateNow Else if ComboBox1 = "Closed" then...

Hello, I have a problem that probably won't matter at all but it is bothering me and I'm hoping someone can help. I"m a novice at VBA, but understand enough to adapt what I find and make it work for me, mostly...so I'm thankful for any help I get both with my VBA education and the...

Hi All, I have been trawling the web and Mr Excel for an answer, but everything I have tried doesn't work. I am creating a userform that users need to be able to add in monetary values. Below is how I have the textbox set up at the moment, but it's not doing what I want: Private Sub...

I have 25 text boxes named in the following manner on a UserForm Name: id_[X]_box 1<= x <= 25 I am trying to write a program which can register a change event for all 25 boxes and populate the corresponding [DESCRIPTION] Labels. Naming scheme for Description Labels Name: desc_[X]_label 1 <= X...

Hi, I was sure that the following code below changes to Red if my Cell from E34 ( 1 ) and Cell (Q34) is ( 0 ) then please change my Textbox to "RED". Can someone check please - cause it aint working. Private Sub Textbox32_Change() If Sheet5.Range("E34").Value > Sheet5.Range("Q34").Value Then...

Hi, I have this problem with code on some PCs (Error 91). Code is used to give user splash screen after start of workbook - where is classical EULA conditions located with button Accept and Decline. I have problems to call Sheet named EULA, which have the text for the Userform TextBox. Where I...