option

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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.

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