add text

Hi all, I'm looking to find a Macro that will look at a list of data in Column A, and add text from the last used cell in column B down to the same row as the last cell used in column A. Sell below: (Data is cells already used, HERE is where the macro would need to put the information. Data...

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

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

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

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

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

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

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

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