edit

Hi all, I want to know if its possible the below scenario: I have a table, with some formulas here and there, but in column O, I have a formula with some conditions and dependent on other 3 columns in same table. What I want to know, is, if I can have some kind of script that every time...

I am a beginner at Excel VBA. I just wanna know what code I am going to use for changing the value of the selected column if found duplicate. For example, I want to create a code that changes the duplicates found from their original name to their original name + "_01" (or something similar). It...

Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...

1. Open the file that has name, time and date 2. auto filter zero in a specific column "AL" and remove all the rows that has zero 3. disable auto-filter than save and close the file 4. copy the same file to another folder and paste it 5. delete the old file that is already there which is 30-45...

Was planning on making a button that utilizes the allow edit range feature which once clicked it will. 1. Lock all cells with value. 2. Cell with value will each have different password. and the password will be the Queue ID (Example - row 2 will only be editable if keyed in password T13P001...

Hello, I was posting a thread to fast. After posting my thread I wanted to edit my thread because of a mistake I made. But I could not find an edit button after posting like in other forums. Please help me.

Hi all, Worksheet_Change(ByVal Target As Range) The worksheet change event tells us which Range (Target) was edited but doesn't tell us how. As we know, the user can change a cell either, by editing it with the keyboard, by pasting a value into it ,by drag and drop or by using the autofill...

Hello and thank you for any help you can provide. So, I have a userform I am using to edit a main database, It looks like this: I am using Vlookup to fetch details in the userform when a serial number is input. The code is as follows: Private Sub txtSerial_AfterUpdate()...

Hi, I've written a macro to take an employee database Sheets("CEP Program"); copy a row representing a single employee & their information to a source sheets("Source Data") and then use the values in Source Data to fill a form in Sheets("Verification Sheet"), and print the Verification sheet...

Hi I have a somewhat unusual question in my request here. I have a spreadsheet where columns may be edited and if they have, I need to keep those and delete the rest. So if there were 45 rows, and only 1 of the 45 were edited, that whole column needs to be kept. I have played around with the...

I'm a photographer needing help with determining how many images to edit per day in order to meet a deadline. The columns are as follows: D) Status - The status column indicates where the client currently sits in the workflow, such as "Scheduled", "Edit", "Reveal", etc. F) Due Date - The Due...

many sources mention that when i add a control button from form controls into worksheet and right click on it, there should be option for properties from which i could change font, color , name etc.. but unfortunately when i do right click only options i see are: cut, copy, edit text, grouping...

I created a file with VBA included. A buddy copied it to use on his network. He needed some fixes so I opened the file and the VBA developer but could not edit the code, it said that the project was locked and unviewable. I've never encountered this before...any idea what would cause this...

Hi all, i have the below piece of code that i run every 200 milliseconds. It works fine however i am looking for a better, more efficient way of producing the same result. I use AutoHotKey to get information from Excel and quite often i will get a Callee error, i assume this is because Excel is...

I have added a subform to the main form so I could have some controls on the main form and the datasheet view on the subform. When I first open the main form I can edit in the subform datasheet without a problem. But if I execute the combo box "cboJobNumber" from the main form to search for a...

When i try to edit macro it says can't edit macros from a hidden workbook. The workbook in XLStart is not hidden. I've also checked to make sure it's not in the disabled add-ins list. If i click in macros and hit run the macros will run. But i can not edit them to assign a shortcut key.

Evening, I have a few macros that do various thing. Ordinarily I would use the Macro recorder to help me but the macro recorder doesn't work with Queries & Connections. Are you able to tell me what code I would need to put in in order to create a Macro that gets me to the Source option that...

In edit mode, when one letter is highlighted and left or right arrow key is pressed, usually, no letter is highlighted anymore. However, recently, I highlighted a letter, pressed an arrow key, and the next letter was highlighted. This is quite handy if I need to replace several letters in a...

Hello, I am not sure if this is possible but I have a situation, where, few cells have formulas in them. I want the cell to be editable by the user where they can overwrite the formula with other numbers but at the same time I dont want them to give the ability to edit the formula inside the...

Hello. I am new here and am hoping someone can help me. I have a userform (Userform1) which has 2 comboboxes, 4 textboxes, 1 listbox and a few commandbuttons. I have the userform working well except for the edit and update buttons. The edit and update buttons are only for the search part of...