text box

Hi, I'm looking for a way to replace certain words inside a text box based on cell values in a different worksheet. I am not sure if a 'Find and Replace' macro is the best way to do this, but here's an example of what I'm looking for: (Inside text box on Worksheet 2) "The quick brown fox...

I have a bar chart with a few text boxes on it. When I select the chart to print it, the text boxes don't print (or show in print preview). I have to select the cells that encompass the chart to make them print. I have even grouped the boxes with the chart and it still doesn't print them...

Hello! I have a pivot table and an associated chart, which I have a macro to update the formatting of whenever the table is updated. What I would also like to add is a text box on the chart to indicate the grand total for columns of each of the two columns fields in the pivot table. Any...

I have a form with a combo box and a textbox. I have entered the following code in the after update of the combo box. Private Sub Combo12_AfterUpdate() Me.Text24 = Me.Combo12.Column(1) End Sub This works, but if I have the data I want in column 2 or higher in the query under my combo box, my...

I finally upgraded to using Windows 7. I'm having problems grouping a text box with an object. I never had this problem using the older version. I used the Control key to select the text box and object for grouping, but I can only select 1 or the other, I can't select both at the same time. I...

I finally upgraded to using Windows 7. I'm having problems grouping a text box with an object. I never had this problem using the older version. I used the Control key to select the text box and object for grouping, but I can only select 1 or the other, I can't select both at the same time...

Hi, I want to know that : "Is it possible to populate a list box from one column in worksheet, as we start typing in the text box. As the letters are typed the list box should be updated with the most relevant match" If it is possible, what is the basic approch to be started. Excel vba...

Hi, I have a list of text boxes (TextBox1 thru TextBox20) in my Userform. Is there an elegant way to populate these text boxes using sheet1, column a, rows 1 thru end of rows? The only way I know is to move each cell's value from the source sheet to the individual textbox, i.e., TextBox1.Text...

I have created a userform where I will enter customer data including First name, Last name, address, etc.; it's all pretty standard. I can tell it to create my file or take the data from the text boxes and place them in the corresponding rows I have designated. I have then created a new sheet...

I have a text box txtYesNo that is populated very simply via VBA code once the field appt_dte is updated: Private Sub Appt_Dte_AfterUpdate() If Me.appt_dte > Me.ConfCollDte Then Me.txtYesNo = "yes" Else Me.txtYesNo = "no" End If End Sub If the text box becomes "yes," I...

My company just recently upgraded to Office 2007, so I am going through some of the pains. I have a spreadsheet that is calendar (February 2011). We put text boxes in each day(individual cells) to show what is due that day. It looks great on the screen. When I look at the print preview all...

I have a form/checklist that is used both online and off. I have cells that I'd like to leave suggestive text in to guide users as to what to put in a cell that can be typed over top of if they decide to use it online. Essentially the text already in those cells won't change, but new text...

Hi I am writing a program and I need to display the bottom value in column A of my spreadsheet; I have a userform which has a command button and a text box, what code do I need to enter to make it so that when I press the command button it displays the bottom value in column A into the text...

Hi, I am a familiar with VBA and have created several tools based on it. I am working on creation of a report right now and find myself stuck. My problem is as follows: The report consists of several (20+) sheets. Each sheet contains 3 charts. I have successfully created all the charts, and...

Hello, I have a textbox placed in the sheet from the insert menu. It is possible to set the transparency of the text manually...right click>format text effect>fill>transparency. Using vba, how could this be accomplished? Any insight is greatly appreciated. <font face=Courier...

Hi there, I'm currently designing a check-in program for my organization what will do three things: 1. The user will put their ID# into a form and click "submit" 2. VBA code places the ID number in the first available cell of the first available row on Worksheet1. The next 6 cells in that row...

I'm trying to get data from a web form into excel. The web query doesn't work because the data doesn't pass correctly (I've tried linking the url in excel and also using the "export to excel" option offered on the form itself, neither work). When attempting to copy/paste the html data, it...

I created an excel file for each manager in the department to enter monthly information, some of which is in text boxes within excel. I linked the text boxes to a monthly report word document by selecting around them and pasting special in word as a linked picture. But if I want to use the...

I have looked thru 20-50 threads on how to insert a picture into an image control on my userform that I have created. I need the image to correspond to the data that gets populated into my textbox6. The data that’s populated into textbox6 is based on what the user selects in the previous...

Hello, I have written an UDF that generates several values. I have written a messagebox that give the results in a text string of about 8 lines. When I dimensioned the function as a string, it returned the entire string without formatting into the cell that called the function. What I would...