question

Sorry for the dumb question, but how do I create a string that pulls from three separate strings? I want the string to format so if TB1=AA, TB2=BB, TB3=CC, the string will be AA BB CC. Using Dim doc As Stringdoc = TB1.Value I can get it to return the first textbox, however when I try to add...

Hi I just watched a video of excelisfun, the link below and he suggested to change text to numbers by using -- in front of a function Right(). My question, why he did not suggest to go to Home-->Number--> then select number to convert to text to number. Another question. If I have the...

Good Evening, I have a Case code question. In having: Case "Tab Name" Now the represents just that, the name at the bottom of the tab of which is the actual name of the worksheet. Is there anyway to specify this in a generic fashion? For example...

silly question, how do i enable macros on my workbook?

HiI have a list and I have just added a new name to the list. I now go to my main entry sheet and when I go to column F and click the down arrow it appears, so far so good.My question is, is there a way of automatically creating a new tab at the bottom with the new name?RegardsStephen

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