edit cell

  1. M

    Dynamic Cell Editing from Another Sheet

    I'm brand new to VBA and Macros, having had the luxury of relying on statistical programming languages like R and Python up until now. Due to some restrictions at my workplace that won't allow me to use R Shiny or Python Flask for the task at hand, I am looking to make what is effectively a...
  2. dss28

    Change one or multiple cell values in a row and reflect the same in diffenent sheets in the same workbook

    I have three sheets (Sheet1, Sheet2 and Sheet3). The data in these three sheets is identical upto 5 columns. the data in the first row is same as the data in first row of 2nd and 3 rd sheet and so on . That means all row and columns are identical upto 5th column. The data in these sheets...
  3. L

    Editable cells in Power Pivot table - Need help disabling

    I've come across a problem I didn't know was possible and need some help disabling it. I originally created a Power Pivot table for my boss. At some point working with it he enabled the ability to edit the cells directly in the Pivot. He is not sure how or when it happened, it was later...
  4. J

    help to exclude a file

    Hey All, I have code that loops through excel files in a file folder and edits those files. My trouble is that the code is also editing the workbook where the code is saved. Can you take a look at this code and tell me how I can exclude my workbook from the editing loop? Private Sub...
  5. L

    Macro Wont Run When cell is selected ... Application.OnTime EarliestTime:=DownTime

    Hi all, I have a workbook that we use in work in work with a timer function that shuts down the workbook when the workbook hasn't been used for 15 minutes. However, if my peers select a cell and go into edit mode then no macros run and then they go home so no one can edit it. Is there a...
  6. E

    VBA UserForm Find, Edit

    Greetings! I am trying to find the best way to utilize my UserForm to find a member, and edit their information (within the found row) based on the values that changed. ---------------------------------------------------------------------------------------------------------------------------...
  7. M

    User Interface: Populating and editing sheet data from different sheet

    I am new to VBA and need some help getting started so bear with me here. I have names and information in sheet2 and a user interface in sheet1. I am trying to edit names and their corresponding information in sheet1 by picking the name to edit through a userform listbox and having their...

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
Back
Top