1. M

    Can't use Option Explicit and Preprocessor constants together?

    Hello, All, I'm trying to use Option Explicit alongside preprocessor constants, like in the dummy code below: Option Explicit #Const TEST_CONST = 123 Sub TEST_MOD() Debug.Print TEST_CONST End Sub When I try to run TEST_MOD, I get a "Compile Error: Variable not defined." It does the...
  2. J

    Pulling from a Vertical worksheet and goes to a Horizontal Spreadsheet

    I am trying to pull information from a Vertical worksheet and put into another worksheet. This is what I have been doing for the past year, but it is time consuming changing the row numbers of the people. =HLOOKUP($B53,'S:\Corporate\Loss Prevention\Schedules\2019\[Southeast.xlsx]Data...
  3. K

    VBA dropdown list

    Hello everyone, I want to add a dropdown list to a selection of cells. My code is adding a dropdown list to the cell but the list contains all the option as one. Meaning that instead of giving the chance to choose either option 1, option 2 or option 3 it gives only one option called "option 1...
  4. Z

    Linking Forms to another Forms

    My Boss asked for a hard task ( for ME) which requires To create a form and inside the form create a Combo Box where i can open a drag down menu and select an option and this option Automatically fill another form Linked to this one. For an example: Form 1 Contains the city, if i choose a...
  5. L

    how to become excel 365 insider

    Hi I have office 365 student version. I went to to file-->acct as per the link below but I do not see Insider option. https://insider.office.com/en-us/join
  6. L

    cells which are blank but not (has space char)

    Hi Lets say you have a big table and it has some cells which looks empty but has space as a character (user used spacebar to delete content). I know there are many way to spot these cells but I would like to learn different methods or how you would do it yourself. one option I can think of is to...
  7. L

    Trust access to the vba project object model

    Hi I am reading about macro settings and found this link about the option [] trust access to the vba project Mine is not check and I ran many small macros without problem so far. I read what is explained below but did not understand it well. Could you please explain to me why I need this...
  8. M

    Error Handling

    Hoping somebody can help, I'm a rookie in VBA (but learning). I have the piece of code below and had 2 questions. 1. I would like to add code so that if the Path isn't available the spreadsheet doesn't give the user an error upon opening. This could happen if the user moves the file from the...
  9. M

    Check boxes, select dropdown option?

    Bear with me as this is not my forte with Excel! I am composing a simple excel sheet for users to complete, I have started using check boxes but what I need is if a user ticks a box, they have to select an option from a list, and the response is populated in a cell somewhere. I know how to use...
  10. J

    Convert HHMMSS to time in VBA?

    Hi, In a database our timevalues are stored like 94500 = 09:45:00 121755 = 12:17:55 58 = 00:00:58 What is the best way to convert these when pulling them via ODBC? Ideally in the SQL query but power query is an option also. Thanks
  11. D

    Help me Excel Community

    Hey Team, I've developed a dashboard but have come across one error and I am hoping someone out there can help me! By using VBA code, I have columns which allows for multiple items in a drop-down list e.g. column A has the option to select Apple, Orange, Banana. Is there a way to produce a...
  12. MUKESHY12390

    Do we have Option ?

    Hi All Do we have option where we can attached "File" while posting question/Answer to this forum? It's been years I have been using this forum but never seen that option. Thanks, Mukesh
  13. C

    Need help with countif

    Hi, I need help with a countif formula. I have one column of data with 458 rows; 4 options and want to count how many times each option shows up in the row. Column A: Option 1 Option 2 Option 3 Option 4 Option 1 Option 2 Option 3 Option 4
  14. P

    Convert the order the first and last name is written via formula

    Hi assuming I have "Driver Name: Donald Williams Jr" in Cell A1 in B1 I am looking formula that will show "Williams Jr, Donald" ...not sure if that is possible so the other option is in B1 have just "Donald Williams Jr" then in C1 "Williams Jr, Donald" thanks for the help.
  15. H

    User Form Option Button

    I have a user form with several option buttons After selecting an option button and clicking on Ok, I would like the button to show the last option button selected it would be appreciated if someone could advise me how to do this
  16. A

    Forgot Password of excel file

    Hello, i had a excel which was protect with password and right now i forget the password, so there is any option to open that particular file. that excel file is a Macro-Enable file. Thanks in advance Amit Kumar
  17. R

    VBA Beginner

    I am working through EXCEL VBA Programming for Dummies from 2004. I am getting the "Compile error: Variable not defined" pop-up. Below is what my code looks like and it is verbatim as the example in the book. I know the problem has something to do with the "Option Explicit" at the top and...
  18. G

    How to detect Userform 'X' or Cancel click from sub that loaded it

    I have a Sub that loads a userform I created. In the sub, I change a label caption in the form and reuse it using a loop to capture the user's option selection for each new context (but with the same options presented). Load frmExample With ActiveSheet For x = 1 To UBound(vValue)...
  19. B

    CDO gmail but don't send, draft email

    Any gmail examples out there that permit the ".Display" option instead of ".Send"? I've searched DeBruin and several sites. Looking for a work around or option that would enable reviewing emails and manually sending. Thanks.
  20. E

    Userform VBA option button get selected option

    Hi there, There's no easy way to get selected option of a option button in a Userform VBA besides read one by one is is true or false (checked or not)??? GroupName works only to avoid multiselection in the group? There's no "grupname.value" option. Thanks

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