question

I apologize for my noobness with VBA upfront. I'm attempting to teach myself VBA while adding some code to a project at work. All help is greatly appreciated. I'm creating a form that will be filled out by others that may not be as familiar with the material as I am. I'm attempting to code...

I am making a userform in excel using VBA. I want whenver a textbox1 is left blank after clicking a save button a pop up window is trigerred saying "the textboox1 cannot be left blank" I know how to do this Function ValidateForm() As Boolean ValidateForm = True If Trim(a1.Value) =...

Hi all, I'm working on a pretty hefty spreadsheet right now which will tally scores during our application review process. The sheet currently has 3 sheets, one with raw scores, one with weight values, and one where I'm multiplying raw scores by their weight values to get weighted scores. The...

Good day to all, This is my first post in this forum...:) I am a novice Excel user and I am trying to learn the ropes in becoming a good Excel VB programmer someday. My question is, it seems that my Visual Basic for Applications has changed. I am trying to record a macro and the the interface...

Trying to decide how to present something to my client and this question came up since I'm brand new to Queries. Say Your Master table is on one sheet and you have a query on Sheet 2. Is there any way scenario in which a person could change a cell in the Query and it updates the master? ~Todd~

Hi, I have a specific problem with some code, and then a general question to ask as well. I started learning/writing VBA code about 4 months ago; therefore, I apologize for my ignorance on a lot of this stuff; anyways, my general question would be, 1. Is there any general / simple way to use...

Hi, I have a table that stores data. It has too many fields to fit on a userform. My question can a multipage form allocate the data to the same row in the table? Thank you

Hi! I would like to create a point systems where I assign different points based on yes or no answers through a dropdown, i.e. Question 1: Yes = 2 No = 0 Question 2: Yes = -1 No = 0 etc... How can I do that? Thanks in advance! :)

I’m new to macros and am NOT a programmer. I can use the “Record Macro” function and assign to option buttons to either hide or unhide pretty easily, but I’m struggling to get it to do what I want. I am trying to create a series of yes/no questions where the answer to the first question...

Hi one and all. I'm new to Excel, so fairly inept with formula etc. I had done a search of questions asked, and found a question that nearly but not quite hit the point. The question posed by 'cmendes on May 18th 2011. What I'm trying to do is to populate cell A1 with AAAA, then autofill...

Hi all, The below code, I am trying to change the "<1" to reference a cell that contains the value 1. When I substitute the cell for the hard number, doesn't seem to work. Any ideas? Thanks! Range("E21").FormulaR1C1 = _...

Hi All I am not sure if this is possible, but I thought I would ask the question in case. I am using Excel for Mac 2016 and have created a Drop Down list. As we scroll down the list - the entry is highlighted in royal blue, but I have been asked if I can change this to our specific green...

I have in first place ask for help about how to get value’s from cell to labels on Userform and get help for that and in second ask for another Function on userform to copy value’s from labels on user form to a new sheets two different Question can be a Double Question

Hi all and thank you in advance for reading my thread. I have a set of numbers in a column M4:M36. The smallest number is 0 and the larget is in the hundreds of million. I would like to create another column to return a value from 0 to 10 where the biggest number in column M would return 10 and...

Hi guys, i feel like this should be simple but i have no idea how to do it, would love some help. Consider the table below. I need a new column on the end with a formula that provides the maximum value from the position column that also has a 1 in the place field for all records with the same...

Hi all, Hopefully a simple solution to this question, I want to basically return the date of the Friday just passed in "ddmmyyyy" format, so a formula to return 19072019 in the example of today's date. If the date were Thu 12th September I'd want 06092019 - if the date is a Friday then stay as...

Hi all, Question for you, why is it that I have to put a 0 betweenthe speech marks to get this formula to return a value? If I take the “0” out of the speech marks I get nothingback? What am I doing wrong. =SUMIFS(V5:V2247,T5:T2247,"",X5:X2247,"0",Y5:Y2247,"EME") Steve

Good Morning is it possible to answer the following question without creating a data list (to reference in a countif formula) I have a range of data in column A of Worksheet 1 1 1 1 2 2 2 5 5 5 and so on The question states which number is represented 10 times. i can work out the answer...

Hi all, been a while! I'm creating another spreadsheet and wondered if anyone can help me out with it. I have a survey that asks a question, with responses to the question being: - Definitely - Likely - Not Sure - Unlikely - Definitely Not - N/A The downloaded sheet displays the answers in six...

Hi all, This is my first time asking question online for excel(mostly just google and have the answer) but i struggle to think of a good way to ask this question on google. Basically I am making a cell at E2(shown below) to show subject 1 OR A2 <tbody> A B C D E 1 subject 1 subject 2...