1. saltkev

    Multiple Text Box Edit

    Good Morning I have a number of Text Boxes All with the same name "Time1". I need to edit each of these boxes using VBA to remove the first character which is a Minus. Your help will be much appreciated. Regards Kev
  2. P

    Unexpected error: "Something went wrong..." when trying to edit a query

    Hi, I've started getting this error when trying to edit a query or create a new query in Power Query Editor. It was fine yesterday and is happening on any spreadsheet (ruling out a specific corrupted file). I don't know how to diagnose and solve this. I have saved the details of the error if...
  3. D

    Deleting a post

    How can I delete one of my posts? I don't see an edit button so not clear how to either edit or delete. Thanks!
  4. J

    edit links

    I go to data and edit links.It appears there are link to another workbook.If I try to break link. The link does not disappear.I try Ctrl + F in the workbook and search for the link, but no search result.How is it possible to delete a link or how is it possible to find where in the workbook it...
  5. sharky12345

    Edit result from AND formula

    I have this which is evaluating cells to see if they match; Presently they produce either TRUE or FALSE - but can it be tweaked to produce either VALID or NOT VALID? I've tried this but it produces '#VALUE!'...
  6. M

    VBA add current date and username when edits are made

    Hi, I found the below code to add the current date to an adjacent column when an edit is made. Note that this code is meant to apply to the worksheet, which might complicate my bonus question. I'd like to modify it to do the following: 1. Add the date to Column L of the edit row regardless of...
  7. N

    Edit from selected list box

    Hi All, very new to VB. I want to be able to edit data from list box. I can get the data to transfer the list box into the text boxes. I then want to be able to edit the text box and move it back into excel. I have stumbling through the below code, but it does not seem to do anything. Any...
  8. D

    VBA Populate Listbox / Edit Listbox based on Criteria on my Textbox1

    I have data in sheet4 (contains 8 columns), I need to populate my list box using criteria from my textbox1 After populating my listbox I will select the cell or data that I need to edit (From the Listbox) and save it on my worksheet. SAMPLE DATA <tbody> A B C D E F G H 1 123 XXX 12 12S...
  9. H

    Edit Links and change source for certain cells only

    I would like to be able to select certain cells that have linked formula's and then select edit links and change the source only for those cells selected It would be appreciated if someone could assist me in this regard Also posted here...
  10. D

    Reply did not appear underneath post

    In the Excel Questions forum I replied to a post, thanking that individual for a solution, but my reply appeared under someone else’s post later in the thread. When the cursor hovered over the Edit button at the bottom of my reply, it said “Edit/Delete”, but when I clicked it, I did not see an...
  11. H

    Where to edit comment of cells

    Hi, Where can I edit comments of the cells below? https://1drv.ms/u/s!Ai8CrEskdewXm1cbebVD-Mm-OXrN
  12. M

    restrict edit of database

    hiya, I have two tables in one database. I have a frontpage menu which gives two buttons. 1. to access form1 (linked to table1) 2. to access form2 (linked to table 2). If I restrict access to the whole database to read only, it means users cannot edit table no.2, which I need them to...
  13. N

    Excel VBA to save email after sent, but only show preview email and not sent email

    I want to save the email in my local folder, and I saw this link https://www.mrexcel.com/forum/excel-questions/361751-vba-saving-email-only-after-send-pushed.html which basically use the class module to save the email after sending it out. However the problem is, the email saved is the preview...
  14. M

    How to get LAST value using INDEXMATCH

    I'm using this formula, which has been working perfectly... that is until it found 2 matches. How can I edit this so it shows the LAST matched value, instead of first??? =INDEX('Q3'!$F$1:'Q3'!$F$332,MATCH(K22,'Q3'!$AB$1:'Q3'!$AB$332,0)) Thanks.
  15. Alex O

    Adding a User Form to ODBC file?

    I’m constructing an inventory file that’s ODBC linked. Said file will be handed off to a clerical assistant when finished. Can a user form be added to edit the query when adding client numbers, or will the user have to edit the actual sql script? If so, are there any tutorials that any of you...
  16. C

    How to allow access to workbook but read only

    I want to allow employees access to a workbook but not be able to edit anything in the workbook. I don't want them to have to use a password to open the workbook. If I protect the workbook then they would need a password to open the workbook. I don't want them to be able to change it from...
  17. I

    Edit to existing range code

    Afternoon, I have the code in use supplied below. You will see that the current range is G13:O17 but how would i then edit the code to include the range G27:O42 Private Sub Worksheet_Change(ByVal Target As Range)Dim C As Range, d As Range Set d = Intersect(Target, Range("G13:O17")) If d Is...
  18. J

    How to organize multiple data stores

    The data part of the macro I'm trying to create may be better suited for Access but it lays out better in Excel. I have 3 or 4 different data stores or the equivalent of tables. Very small business. Nothing to big. main employee list. A positions list they like to be able to edit. A training...
  19. A

    Worksheet Protection

    Hello folks, I have a worksheet that needs to be shared with other members of staff. The spreadsheet has been set up to have edit ranges that allow myself to edit the full spreadsheet and all other users to edit only portions of the sheet. The sheet is protected and shared to the other users...
  20. S

    13m and 40k From Text To Number

    I watched the amazing tips at this video posted at your youtube channel: <yt-formatted-string>Excel Magic Trick 981: 123.45M From Text To Number, 123,450,000 From Number to 123.45M</yt-formatted-string>but what if I have my table like this: 4m 284.6k 1.4m 10m 7.7m 698k 154k 2.7m 20k in case I...

Some videos you may like

This Week's Hot Topics