1. J

    private excel.application instance for only one workbook

    Hi! i'm trying to adapt a code i found in an old thread : Don't allow another workbook to open in this instance? I want to secure an instance for only one workbook, so i adapted the code to fullfit my need. when i open the workbook wich i want private instance, i see 2 situations case...
  2. R

    Prevent changes to specific worksheet (VBA)

    Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...
  3. H

    Which is better line in code for Module

    In Module of my Workbook (coded.xlsm) and for the Worksheet (tab named “ZZZ”) I am using User Defined Function to get outputs in some cells where UDFs are there. 1 line of the code is If Sheets("ZZZ").Range("WA10").Value = "=1" Then GoTo finish End If Should I replace the above lines with...
  4. D

    Coloring of different shapes based on time

    Hi There, I am trying to solve the problem with coloring the shapes based on time and I am struggling with it for some time so hope someone can help me with this. I have 19 shapes on excel sheet and each is having the name Bankomat_ and then number from 1 to 19. The output should be that...
  5. M

    Userform Hide Workbook

    Hello All, I have searched online for this issue but couldn't find a proper solution. I have a userform that open (while the workbook itself remains hidden) using the following code: ThisWorkbook.Windows(1).Visible = False If Workbooks.Count = 1 Then Application.Visible = False...
  6. K

    VBA Excel for Mac to run .scpt file or open Dymo app

    First, any help is greatly appreciated. I'm trying to solve a problem for a co-worker. I am also new to VBA and scripts. We use excel for inventory and a Dymo Labelwriter 450 Turbo. My co-worker's labeling process is typing in one item number into the Dymo app and then printing it before...
  7. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  8. D

    VBA one cell returns date of last time another cell was edited

    Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...
  9. A

    Application.ScreenUpdating = False issues

    Found this post, ScreenUpdating = False not working, that is having a similar issue to mine. From what I've read this is a common issue with Excel after an update Microsoft did. Below is my code and I cannot figure out how to keep ScreenUpdating set to false. It's not a major issue but the...
  10. S

    Macro/VBA for finding data locations outside Excel

    Hi All, I have here a problem wherein I want to find the location of a certain data with no match outside Excel. Below are reference photo and explanation for clearer description of the problem. Here are the locations of the data that I will be putting in Excel. This is a sample of what's...
  11. M

    Noob Help Please

    I am hoping someone can help. It seems like such an easy thing to do and I just can't find the answer anywhere. So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes" The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
  12. A

    SMS with App

    Hello All I want to open an application with any code in attached and want to send these number one by one through that application! That application is bushbullet, which linked with my mobile msg box! for more understanding! When I hit button in sheet that call...
  13. S

    Open Another Application by Excel with VBA

    Signal is generated in Excel Either Buy or Sell. The Vba should Open the Another Application Perform Functions Like enter amount, name,.....From Excel Only then Submit and Close. Wait for next Signal and Repeat the same Process Again.:)
  14. Nelson78

    Application.SendKeys "{TAB 2}" does not work

    Hello everybody. I'm a newbie about automating external application via sendkeys method. Now, I can get in the external application, I can write (for example "5"), but I cannot shift the focus two fields on the right (as I manually do without problem). I mean: nothing happens. Maybe somebody...
  15. R

    Barcode scanning application

    Hi Hope you are doing well!! I need to create an excel sheet for store support. Application details: I have a material which has a QR code and some Location racks with QR Code. Whenever i get the material to my store i will scan QR code in material and rack.this two data should be recorded in...
  16. CPGDeveloper

    Bound vs. UnBound Forms

    So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive. The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as...
  17. E

    Can't copy and paste after using VBA code. Any help please

    Hello guys I'm so glad to be part of this forum and to learn and share excel best practices. I'm a novice in VBA and need some help on the following. I created a check-list with a multirow highlight feature through VBA that I got inspired from an amazing guy. However I can't copy and paste...
  18. JenniferMurphy

    UDF stops running if I hot-key to another task

    I have a UDF that does some iterative calculations. It can take anywhere from about 2 to 8-10 seconds to complete its work. The data, which I enter into an InputBox, comes from another application. If I hot-key over to the other application, the UDF stops running until I hot-key back. Is there...
  19. M

    Automation Error Exception Occurred

    Hi everyone I would like to ask a help regarding on Automation Error Exception Occurred. I have created an Excel application. Excep as a front end and Ms Access as a backend. Basically all the data that will input in the Excel userform will be exported to Ms Access. The application is running...
  20. VBE313

    How can i replace this "a" without application ran code?

    How can i replace the bold part? Function test1234() Dim a As Long If ActiveSheet.Name = "Sheet1" Then Else End If a = Application.Caller.Row + 1 Do While Cells(a, 1).Value <> "Yes" If Cells(a, 2) = "Yes" Then Exit Do test1234 = test1234 + Val(Cells(a, 2).Value)...

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