text box

Guys, Is it possible to select all shapes (textbox) in a particular row and change the textbox values in it. I am having 3 textbox shapes in each row. I want to select only the shapes of the activerow and then change its values using macro. Somebody help for this problem. Thanks in advance.

Hi Guys, Important Help Required: Please reply if you have answers for this. I have a Two Separate Sheets. In First Sheet Am Having a shape with three text boxes in Cell B2. Each text boxes with a name "TextBox 1", "TextBox 2", "TextBox 3" and a freeform shape with name "Freeform 1". In the...

I am working with a macro that has old data in it that is not useful for what I am using it for. I was wanting to see if it is possible delete the unusable data that is older than a certain date (always changes). It can only delete the info in column A-G since there is critical info in columns...

:mad: I have a text box linked to a cell on a different tab. Eventually that tab will be hidden and password protected. The tab that has the text box is lock in properties, and locked in format controls. and the tab (worksheet) is protected with nothing selectable; however, when I click on the...

Hi, I wanted to set up a validation that would ensure that only a number was entered and if not then a msg box will pop up to prompt them. The text box will be a series of numbers varying in length each time it is entered At the moment I have the following code: If Not...

I've built a visual containing several text boxes that have the names of activities typed into them. These text boxes are in a kind of table that has five defined rows (each row pertains to a particular resource used), and columns that depict when these activities will happen in relation to the...

I need a userform that when I enter info in a textbox and click a command button it will add that information to a range named "Grade" this range is located on sheet 1. Thanks for looking

Hello, I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where...

I have a cell that displays a text string via a formula. I want to link the cell to a text box in such a way that it displays the values displayed in the cell. Would this be possible without using VBA?

Hi, </SPAN> I have this code:</SPAN> it suppose to take one input and calculate for the other variables the problem is that once it writes the outputs the other text box it activates the second text box code so I keep getting the error ‘13’ and the result is the same no matter what number...

I have a form control text box with a fixed width that expands downward to accommodate however much text is entered in the box and the text is set to wrap. My problem is that if a carriage return is used anyplace in the body of the text (like to start a new paragraph), then the last line of...

Hi All, Need to amend the following code so that 1) my array items are separated by commas and 2) they populate a user form text box titled "tbDocumentName." Thank you! Shaun With Application.FileDialog(msoFileDialogFolderPicker) .InitialFileName = Application.DefaultFilePath &...

Is this even possible I wonder? Using excel 2007. My colleague has created a custom shape out of a square that is also used as a text box. I prefer it to any of the defaults and, rather than cutting and pasting from another workbook, or making from scratch, I wondered if there was a way to...

Using the developer tab, I inserted a dozen or so textboxes. When I click on the control, there is a formula something like =EMBED(TextBox.1,"") Suppose I name one of the textboxes "txt11". How do I access it in code indirectly? For example: NOT txt11.Text = "123"...

Hey ive been looking everywhere for a solution and my brain is now wrecked :( How can you paste information across multiple userform textboxes? eg copied info = 06022012 textbox1 maxlength 2, autotab true textbox2 maxlength 2, autotab true textbox3 maxlength 4 When textbox1 is selected and...

Hello<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have the following problem and I need some guidance:<o:p></o:p> <o:p> </o:p> I have a list of tasks, ordered as:<o:p></o:p> <o:p> </o:p> S/L, Open Date, Short Description, Status, Closing...

I am trying to populate a combobox (CboMilestones) based on the project number that appears in CboProjNum. I need the values of certain columns to be added to CboMilestones. My spreadsheet is laid out in a paticular order based on a SQL upload that I will have to perform (1st column = project...

I have spreadsheets where much of the text has been created by adding a text box to the worksheet. To use the spreadsheet with some other software, the text has to appear in regular Excel cells. Apart from spending hours copying and pasting, does anyone know of a way to make this change ? Thanks

Hi gang, I had a frustrating problem with a shape on my worksheet. It is a Text Box Shape (not a userform type) and it is supposed to display text from a specific cell. The cell contains an INDEX formula, so the contents change based on a scrollbar control elsewhere. My problem was, the...

I need to remove the Chr(10) symbol (a square) from a multi line text box. The text box is on a form and then the contents are entered into a comment box by a button. The "returns" are not sighted until entered into the comment. The nature of the data requires a new line in the text box like...