added

Morning all Is there a way that when data is been added to a Userform Textbox and Return is pressed to start a new line that ";" is added to the end of the previous line? The reason i am asking is the data being added are multiple email addresses and when these are added to the new email via...

I am using a UF that the user enters details on that need to be appended to a range in a worksheet. Once the data has been added and pasted into a holding worksheet, the UF is closed via an Unload commande but when some of the non UF code is executing, the code for some controls are executing...

Hi I have a UserForm with option buttons combobox and textboxes at the moment it is used for booking in and I have added another option button to book out and I need it to deduct the value, see link below to see how it works. https://www.dropbox.com/s/m95u5skdxnjgj0x/TESTER1.xlsb?dl=0

Hi, I am using Indirect Drop Down lists for my project. =indirect(e30) etc. I have a rage of name ranges in the name manager. I am using this sort of formula to adjust the lists as things are added or removed: =Sheet1!$C$2:INDEX(Sheet1!$C$2:$C$1000,SUMPRODUCT(--(Sheet1!$C$2:$C$1000<>""))) My...

How do I create a code for changing my ActiveSheet to a name and subsequent added sheets with name +1 ? E.g. WS1, WS2, WS3

I have a spreadsheet with a drop down list. This drop down list may need to have new entries added. At the bottom of the list, I want another option added, "Add new organisation". When this option is selected, I want someway of adding a new organisation to the list of organisations. How would I...

....thought I would ask anyway. i have 5 different workbooks (data added by team captains) that feed into one table combined by a power query (viewed by team manager). Captains add data to their table and the manager can see this when he refreshes his query. All is working well. Now, is...

Hi Guys, I hope you can help as always. I have a file that I want to print up to a certain row which contains the word "END". If there is no "END" in that column, I want a message state that. I have set up a Formula to automate the name range and added a button to simply print the print area...

Would an Admin or the site owner like to answer this question please? Regarding: Hack of MrExcel https://monitor.firefox.com/breach-details/MrExcel Why was there no notification sent from this site, at least I was never sent an email about this? Why wasn't a PM sent within the site which I...

Afternoon all I have a Userform where I can select a file using FileDialog. When I select the file and press Open the file does not open, but the address of this file is pasted into textURL. When I then press the command button "Add" this line of text is added to a textbox "txtFile" within...

I have a Userform which is populated from a worksheet using a Combobox selection, or data is added to the userform and then added to the worksheet. Within the Userform I have a Checkbox that indicates if a certain piece of paperwork is present for that specific Project. If this Checkbox is true...

I am not sure if this is possible in Access or Excel for that matter... In my data I have a field Client PO. I am working on a project where I need to pull all line items associated with about 74 different PO #. There will potentially be additional lines of data added with these PO's. So I...

I added a trendline to a graph. How does excel figure out the trend?

Hi. I have a Userform that some users complete to update info on a (large) table. I've added a bit of VBA to get the date added when the user who has opened the spreadsheet makes a change to the database but I'd like to be able to add their name too. However, when I use Application.Username I...

[/IMG]Hi Is this possible... I have a group of signatures on a worksheet (images) I would like to select an image and rename it to the name stored in a combobox by pressing a command button. Is there a way of changing the selected image? activeimage? Thanks Mark

Hi all, I have found a million solutions to highlight differences, but I'm having trouble finding something that accommodates the addition of a row in the middle of my data. The idea is that I have two sheets with a few dozen columns--let's call these sheets A and B, with B being the newer...

Hi: This formula: =SUBTOTAL(9,I2:I4489) does not auto extend to include newly added rows, example of I added row 4490 Could you help please? Regards, Sean

I have one of these on my worksheet but there is no code anywhere that would have AddItem'd it. I must have done it but I can't remember how. Tried adding another one as a test but I can't see where items would be added to it. What as I missing ?

Hi everyone, I copied a piece of code from another forum for a project I am busy with and amended it here and there as per my needs. All was working perfect until I realized that, despite my instructions, some of the staff would insert additional sheets that they are not supposed to. It works as...

Hi Friends, I'm a member of this forum for a long time and found many VBA codes that fit to my works; thank you very much. Today, I need another VBA codes but I cannot find it I need VBA to add the total 20 rows above text in column B (FAC_7), accept for the first row (1063109), based on the...