text box

Hi. I have created an Excel form that allows users to add up to 90-odd pieces of employee data including a picture of the employee and then send the information (as an attachment) to an email address via the commandbutton1.click event At the other end, the receiver of the email saves the...

Using a macro, I need to insert a text box at the current location in a spreadsheet. The text box and text will have custom formatting and will contain the same formatting and content every time it is generated. I was going to insert a pic of the text box here but I don't see that I can...

I want to add a set of rectangular text boxes / frames all the same size, but with different amounts of text. I'd like to have the box / frame accommodate the additional text by converting it to a scrolling canvas, scrolling within the text box / frame. I do not want the remedy for too much...

Hi all! I've been visiting this site for quite a while now for questions about Excel and VBA, but this is the first time I have had to ask a specific question! I'm new to VBA, but I'm learning. I recently learned how to work with user forms and had an idea for something that might be handy at...

Windows 10, Excel 2016 We have some workbooks with command buttons and text boxes on the opening worksheet. When the workbook is opened, sometimes the buttons and/or text box fail to appear. If you were to tab to another worksheet and then back again, they appear. This is not a critical...

i have a userform.. when a form loads i want to select the range from active sheet and after i select a range i want to display the selected cell address in textbox.. i want to do this automatically without using inputbox or clicking any button... i want to select the range and its address...

I would like someone to help with writing a code to be able to enter a number in one text box and have the program use that number to search find it in column A and then display the correlating column B data in another text box. If this is not possible please let me know. Ian

I am working on code to take inputted data from a userform and then paste it on a worksheet. I have a loop created to populate fields into the text boxes based on data existing in the sheet. I want to allow the user to update or add data to the text boxes and then fill back into the sheet. I...

I'm using Excel VBA to control IE - more specifically a javascript multi-page form with several text boxes and other elements such as drop down boxes. The drop-down boxes and multi-select boxes have an "onchange" event that I am successfully firing. And I am able to fill the text boxes out...

Good day to all, I am in need of a VBA code that can identify the missing part numbers from a list (via vlookup function I guess) and list all those part numbers in a textbox so the user can choose to upload the parts in the database or ignore Thank you in advance for your help!

Hello and thank you in advance if anyone can help me. I am trying to create a Button Click to open up a Text Box that can be Edited. And then I would like that Text Box to be placed on the active sheet. Nothing fancy. The goal is to have a place where employees that are viewing the page can see...

Hello, I have several Text Boxes (ActiveX Control) on my worksheet. On a separate worksheet (same workbook) I have a single column of cells that have number values that change. I don't think it's relevant to explain how or why they change, but it's because of a VBA macro where a user selects...

Hi, I have form which will ask the product ID's. Whatever the user entering via text box should get displayed in list box. Example: Form with label "Enter the Product ID" and followed by a text box to get the input and three buttons "Add to the List" and "Delete from the List" and "Close". I...

Team, Andy Pope created a fantastic USA Interactive Map application (AJP Excel Information) which will allow users to color the states (each state resembled with an object) according to a data value in the range 0 to 9. Based on Andy's map, I am building a dashboard to show revenues by state...

Hi, I have a text box which will get the product code of each product. All the product will have 10 digit and first 3 digit will be letters. I want to know how to validate the input entered in the text box is matching the above parameter. For Example, the product code will be ABC1234567. If i...

with help I have created a form that updates adds scrolls through data on a spread sheet there are more than 40 textboxes and a couple of combo boxes only 11 of the text boxes show information and the first one updates to the date (todays) every time I update the information (the first text box...

All, I have a workbook with an absurd number of worksheets... Is there any way I can use a text box in a userform to search and open a worksheet?? I already have a userform with a textbox and command button... I'd like it so that after you enter text into the box and click the button, one of...

can any body help to change this form which works perfectly for inputting new data into a spread sheet to being able to edit the existing data in the spread sheet,scroll through the spread sheet to check existing data and still be able to add new data. Many thanks in advance. Private Sub...

Hi, does anyone know how to link a cell value to what is typed in to a text box? what I need is to be able to type into a text box, and then have the cell value update automatically. thanks

Hi all, I am looking for a VBA that, when the excel doc is opened, will ask the user to input their name into a textbox before they are allowed access to the spreadsheet. When the spreadsheet is then saved it will save that users name and the time the saved it in a cell. Doesn't matter which...