case

Hi All, I hope that you can help me in this. I have 2 sheets, using a list of data in the other sheet to enter the data into the first sheet, I’ve used a VBA code to get a searchable list with a combobox, what I need is to get the value removed from the data validation list if used before to...

Guys I developed a spreadsheet that when the file is opened it sends an e-mail after 1 minute and then it auto close the workbook. Application.OnTime Now + TimeValue("00:01:00"), "SendReport" There are certain days that I need to send the report. So I created a task scheduled on Windows to send...

Is there a way to add only a range of cells instead of entire row? Here, I will like to insert from Col B to Col O. I have other data adjacent the range B:O and the entire row is interfering with the layout. I will be more than happy to find a work around. Thanks in advance...

I have a drop down box on a sheet called Start_here with 2 options and each option is a town. When the option is selected and a Continue button is pressed I need a header and footer to be loaded onto the sheet quote_sheet depending on the town selected. The headers and footers are images...

Hello everyone, I have my userform almost done. I am able to do my searches, a it sorts the data properly. It will show first match in my form, but have added Prev and Next Buttons to look through similar matches. I am not sure how to get it to work with the search results. Here is a screen shot...

Morning, Please could you check my code & advise a fix. I open my workbook. It defaults to INCOME (1) to open first. I see the msgbox asking me to select MONTH & YEAR I choose to select CLOSE FORM The form quickly coses then reopens. I choose to select CLOSE FORM again & it closes. Now i can do...

Hi I have a table with multiple columns and a form that adds data to each of those columns, as a "case". I also have a separate function that adds data to some of those columns, based on the value in column A as a "case update". How do i get the remaining blank cells in that row to fill with...

Hello gang! Quick question hopefully with a simple answer. Why would I get a FALSE in a cell that I set = to ""? This is in a Select Case statement. TIA

Hi All, I have the following piece of VBA code that ensures if a name is entered in column 14 then then it makes sure its proper case or changes it. However when you paste in more then one line in to column 14 i get the error: Run-Time Error '13' Type Mismatch. Can anyone think how to stop this...

Hi all, I'm declaring my source as "src" and my discount as "dis" src will always be a value, but dis can either be a value or blank. An example will be src = NQS and dis = "", or src = NQS and dis = NQS20 My code is below: src = Cells(ActiveCell.Row, "F").Valuedis =...

Hello, I came across this code which changes the Font color for individual names within a Range. How can i also include the functionality to change the font Name, Style Size and Boldness for each individually? Thanks for any help! Sub Change_FontColor() Set MyPlage = Range("NamesList")...

Hi All I want to have a Function with select case that: range value is range(A2: last row) and group by range(B2:lastrow) like below table have 04 group: The code of function like this: Funtion () for i = range(A2: lastrow) select case group by range(B2:last row) Case a = Array("B004") 'group...

I have a ComboBox that I am trying to get the BackColor to change based on a selection. There are 11 ComboBoxes on the sheet. After I have gone through all the boxes and made the selections I hit the finish button which runs the VBA code. Using ActiveX ComboBox. This is the code I tried using...

Hi Mr. Excel, I've scoured the internet and can't find the answer to this question. Everyone seems to get stuck in the same place (case #1, case #2, case #3, case #4). The guidance for the SolverSolve function indicates that you can use ShowRef to pass a macro/sub into Solver after each of...

Good morning. I am working on the same spreadsheet described in this thread (https://www.mrexcel.com/forum/excel-questions/1112241-hiding-rows-using-vba-multiple-criteria.html) It is a sheet where based on the answers provided in a set of dropdown boxes, certain rows need to be hidden...

Hi all, I have three (3) button in a Group: Group Name: Sorting Button Names: FirstNameSortButton LastNameSortButton LocationSortButton Since a ComboBox cannot show more than 1 column when the "ComboBox1_Change()" event fires, I had to overlay a 2 column ListBox on top of my ComboBox so all...

I'm relativity new to VBA. I am hopeful someone can help me with the below macro. The Macro takes a day of the week like Monday or Tuesday and converts it to a real date based on whats imputed. It works the way I want other than, I need it to be formatted as a 2 digit month 2 digit day and 4...

Hi All, I need help with a Select Case in my code. I'm new to VBA and have never used the Select Case function. With my online research, I found some examples, but none is really giving me the information that I need. When the user call a UserForm (frmResource) from any one of the sheets Monday...

Hi again, I got something I think is a big problem for me but I don't know what you think: I have a loop like For i = 1 To 100 ......... Next The loop is pointing to numbers in column B. However, all the numbers may not be present. For example, 2 or 54 etc, may not be available in the...

I have drop down lists in column O where you can toggle the status from "blank", to "open" to "closed". What I would like to do is have a certain macro run every time the status is changed in any of the cells in column O. the following vba code that I currently have (that I inserted under...