text box

  1. Z

    Change font color in a text box based on a condition

    Hi, I started recently to learn VBA and I need some help with changing the font color of a value inside a text box based on condition. I tried below macro but it changed the text box color instead of the font. Can anyone help? Sub Set_Color_TextBox()...
  2. M

    Dynamic Print Range (+ Inserting a text box)

    I'm trying to create a dynamic print range from A2, to F2, and extending to the last line with text. I've tried this code, and just can't seem to get it. Sub printFigure2() Dim ws2 As Worksheet Set ws2 = Worksheets("Figure 2-2") With ws2 .ResetAllPageBreaks With .PageSetup .PrintArea =...
  3. E

    Is it possible to prevent a text box from automatically stretching?

    Here's my situation. I have a text box in column A. In the columns to right is where my data is entered. Sometimes the data in those cells are wrapped into multiple lines, which automatically increases the row height of those cells. I have no problem with those cells adjusting their row height...
  4. J

    Internet automation 'P' Tag text field

    Hi, I'm trying to populate a text field on a webpage; it looks like this: Using Chrome's element inspector I've determined the associated code to be: <code style="font-style: inherit; font-variant: inherit; font-weight: inherit; white-space: inherit; margin: 0px; padding: 0px; border: 0px...
  5. G

    Pop-up message if specific cells contain value

    Hi there I would like to generate a pop-up message "Warning! Please check value!" if any of the following cells A4, D5, G7 contain any character. Thank you in advance!
  6. V

    VBA insert cell value to named text box and save

    Hi, I am having a bit of trouble getting this code to work. I have broken it down simply to have a single text box in the word document 'Word.docx' and have named it "Test" using the 'plain text content control' I have clicked the design mode all on the developer tab in word and then changed...
  7. D

    List box selection to a number of tboxes

    Hello all,, please forgive me I posted a similar question a couple of days ago but did not explain very well Im trying for our local charity to write a medic logging VBA Excel,, one of the user forms is to log up eight drugs (ufmedication) the form consists of a listbox (lbdrugs) sourced from a...
  8. A

    Linking Cell value to text box per row dynamically

    Hi I have a problem I'm trying to solve for quite some time. solving it will help me a lot, saving much time. I'll try to describe it to a simple use case and if there a solution is found i'll be able to use the principle for the more complex need. Here it goes, I have a table with two...
  9. P

    VBA to copy Excel data range and paste in PowerPoint text boxes

    Hello, I do not have much knowledge in VBA programming but would like to automate a repetitive task that I am doing every week. I need to copy a range of cells (horizontal/vertical range) with its font color from Excel and then paste them into PowerPoint Text boxes. I am currently manually...
  10. A

    Form Control is Not updating range

    I have a user form that accepts user input and is supposed to put it on a worksheet. The form control has 2 textboxes, and IngredientName and Percentage. The user enters info into these boxes and clicks "Add Ingredient". This is supposed to place IngredientName in Cell G10, and Percentage in...
  11. D

    Autofill or auto suggest in textbox

    Hello everyone i have created a userform AND now the issue is i need a code TO autofill or autosuggest text in the textbox, for example if i have already entered text 'JOHN' and next time if i type J it should suggest me JOHN. is there any vba code for that pls help me as i need to submit my...
  12. A

    How to extract multiple textbox values in userform to excel sheet through VBA using a for loop

    Dear all, How I can extract multiple text box values in a userform to an excel sheet through a VBA for loop. VBA script is written below. ("tb_Model" & i portion is having error) 1. Tbl_Orders is an excel table 2. tb_Model1, tb_Model2, tb_Model3, tb_Model4 and tb_Model5 are text boxes in...
  13. N

    Overcome / exceed / overtake maximum limit of textbox in userform

    I'm using Excel as a primitive but very practical offline grid database. When needed, the Excel file is then uploaded and it populates a mySQL db. Now I added the support to images by encoding them base64 and save the string into a cell (mySQL will use the content of the cell to fill a BLOB...
  14. C

    Get text from PDF using Excel VBA

    I have a PDF file with various fields in the document. Addresses, cofirmation numbers, amounts..etc. I'm trying to open a PDF, grab this text (which changes) and put the information into excel. I'm able to open the PDF in Adobe Acrobat and edit the text and images. When going into Edit...
  15. C

    Copying one Cell of text in excel and pasting it into PPT as a textbox

    I have written a code that enters information into one cell, populates an excel template I've made, then creates a PPT file and slide, pastes the template in, creates a new slide and goes onto the next data point in excel to populate the template with the new information. It is doing all of...
  16. P

    Text box information in Chart disappears when published to SharePoint

    I'm using a text box with a formula in my chart to show the current high value on the entire chart. It works fine in Excel (2013) but when I publish to SharePoint (2013) the data disappears. A text box with static data shows fine in SharePoint. My formula is a simple cell reference (='Table...
  17. B

    Add textbox 'legend' to a picture on a worksheet using VBA

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

    Macro to insert a preformatted, pre-populated text box [Excel 2010]

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

    Text boxes / frames of equal size and variable content

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

    VBA cell counter

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top