1. D

    When cell with formula changes -> edit adjacent cell

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

    VBA: find duplicates and change

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

    Editing Auto-populated Text

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

    Search copy paste delete the workbook with date time in the name

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

    Button Triggered Allow Edit Range with password with different password for each cells

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

    editing a thread short after posting

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

    Worksheet_Change(ByVal Target As Range): How was the Target Range changed ?

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

    Equal number and date being treated as different when comparing them

    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()...
  9. A

    How to Move to Next Row, start over, unless blank

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

    Deleting Columns in spreadsheet if column has not been edited.

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

    needing formula to calculate fulfillment needed per day

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

    changing properties of command button

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

    Project locked???

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

    Alternative method fo simple function?

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

    "subform datasheet view will only allow me to edit when first opened"

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

    Can't Edit Macro From Personal Workbook

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

    Using VBA to go to Source edit in Power Query.

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

    How to get into that edit mode?

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

    How to restrict user to stop editting a formula in a cell but can enter any value if required.

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

    Edit/Update listbox and activeworksheet

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back