text box

I'm looking to create a VBA to filter the entries in a column (either strings or numbers) based on the input in a text box. Currently I was looking at using the ActiveX TextBox to hold the input. Ideally the function would search for partial matches as well as exact. An example would be that...

Firstly I'm new to VBA, but trying to learn to make Excel more useful in work. My company is using Excel 2003(!) and I'm trying to create custom buttons which add text boxes to selected cells - I want to create a series of buttons to create different coloured text boxes. Through lots of...

Hi, I am using around 200 individual text boxes in a single worksheet that each contain a formula pointing to the value of a unique cell in another worksheet in the same workbook. Each cell being referenced contains a numeric value. I wish to apply conditional formatting to the value in the...

I am trying to form a macro that copies a range of cells from an excel worksheet to a text field in internet explorer. I am able to get the macro to navigate to the text field that I want my cells to be copied to and I am even able to get something to copy to the text field. However, the result...

Hi there I have a really confusing question , but I will try to make myself as clear as possible... So I have a registry Book, in which there are over 100 different worksheets, each asigned to a specific ''assay''. Each of them will have a cell called "Sample" next to which the sample number...

Hi everyone, I was wondering whether it's possible to insert line breaks into a text box's text linked via formula to a cell. For example, Cell A1: "Hello, pleased to meet you. I'd like to buy an apple" text box: =A1 -> text box displays the following with no line breaks [ Hello, pleased to...

Hi gang, I'm using Excel 2010, and know nearly nothing about macros. I need help making a search macro, and associating it with a "search" button and related text field. I need to make a book where the user enters the keyword, and is able to search for it via this manner (rather than the...

I've got a major issue with all the activeX Text boxes on my sheet, it seems whenever the part of the sheet that text box is in, is hidden, it completely screws up. It changes it's background colour to the border colour and when you hover the mouse over it, it immediately crashes the workbook...

Hi Everyone, I really need some help and ask if it is possible to join the values from two seperate text boxes into the same text box on the same userform?

Hello All! A bit of help please? I have created an excel worksheet that will provide budgeting and estimating tools for my project managers. All data used to be manual entry and took a good while to complete. I am trying to automate the process with VBA. I created a UserForm called...

Good day!! I really need help! I made a form on excel 2010 and I included several texboxes with activex, there are no codes on the macro for the texboxes and they work fine except that when I press enter nothing happen, I want the enter key to take me to the next textbox, i've looked on...

Hi all, I'm trying to make an excel sheet that will fill in labels to a 96 well plate in order to sort and calculate the data. The problem is when i set up the textbox in the user form i want it to pull data on the plate format from cells that have already been filled in using another userform i...

Hi I want to be able to use the tab key to move from one active x text box to the next active x text box in a spreadsheet without using any macros. The controls are not in a vba form. The document will be protected and locked in its final form. I managed to fluke this in Word and have also...

Hi folks, I have tried numerous versions of the code below; some from this forum and some some the VBForums. When I exit textbox177, I need the input to format to the Vessels c29 exactly. Then as seen below take that number and depending on the case selection do the correct math. The math...

I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand. Everytime the form is loaded the text box evaluates the ampersand and so it disappears. C:\J&B changes to C:\JB and so the subsequent code doesn't run. Is there a way to escape the...

Objective: To remove textbox from worksheet Concern: Each time I have tried to do this a different number appends to the Object TextBox. I need the textbox to be generic so that I can call in the future and delete it without knowing its specific name. Sub removeTextBox() ' ' Objective: To...

Hello all, I have the following problem. I would like to link the contents of a textbox (which are numbers) to a cell so i can change the contents of the TEXTBOX and give me that number on the CELL.Not the reverse. The problem is I have a great range of drawing lines that have a textbox next...

Greetings, Hopefully the title says it all. I'd like to be able to select a range of cells which has text boxes super imposed on it, and delete those text boxes. I can't find anything, is it possible? I'm using excel 2010 on a xlsm file. Cheers, Geojim

Hi Team, I want to fill the text box with the word "Excel" when i click the command button which i created named as Print. Below is the example form which i created: Label 1: TextBox1 Label 2: TextBox2 Print (Command Button) So if i click Print command button by placing the cursor in...

Hi Team, I have created a user form with Five text boxes and also i have a command button named as "Print". Whenever i'm clicking the command button Print, only the active text box needs to print with some content like "Hello". I was aware that in excel sheet we have to use the code...