add text

  1. T

    VBS newbies...

    We are trying to write a script that opens Internet Explorer into a webpage that acts like a DOS screen. We then need to begin typing into said webpage. Below is the beginning code we have managed to make but it does not make the IE screen the current active screen to begin typing into and we...
  2. T

    Excel VBA add text to TextBox without overwriting existing text.

    I have a textbox on Worksheet A. The textbox name is TextboxB. I am trying to use VBA to add text to the end of the textbox without overwriting the text that is already in there. Please keep in mind these are textboxes on worksheets that are shapes, not controls. Using the following put's...
  3. E

    Adding a text value to the end of a formula

    Hi, I want to add a % symbol at the end of my formula. The formula itself is just one value divided by another and multiplied by 100 =B6/B5*100 I can concatenate this output with a "%" in a new row and then hide the previous row, but I was hoping there was a way to add the % onto the end of...
  4. J

    VBA Format Cell based on number sets

    Having some issues here. I have a report that i pull multiple times a day and in Column L some cells have no data and others may have anywhere from 4 - 20 numbers. I have to go into the cells with the numbers and separate them by every fourth number and add UN in front of them. Example BEFORE...
  5. D

    Find word and add text

    Hello everyone i have small doubt i have created a userform with few combo box,now the issue is when i select values from few combo box those values should get added after a word ,for example lets in cell a1 there is statement "THIS IS PEN" which is predefined and when i select a value in combo...
  6. E

    Create dropdown menu with text in background

    Hello, I've been searching the internet for a solution, but not sure one exists: I want to create a dropdown menu which allows the user to select 'red', 'amber', and 'green' and changes the colour of that cell as appropriate. This part I have achieved successfully. However I would now also...
  7. W

    add last day of month to mm/yr column

    I have about 200 column of US dates that I need to insert ending days in the month for (30th/31st/28th). Unsure of how I should go about it...if,then, etc. <TABLE style="WIDTH: 33pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=44><COLGROUP><COL style="WIDTH: 33pt...
  8. L

    Adding list box text together

    Hello, I have tried numerous ways of getting this to work, but i only have a limited knowledge base with which to work with. I have created a 3 column listbox and figured out all but one function. What i am trying to do is this: Dim items items = UserForm1.ItemList.Column(0, 0) items2 =...

Some videos you may like

This Week's Hot Topics

Top