Search results

For the basic MsgBox, you can't change the color. If you want to build your own UserForm, then you would be able to customize the color. In your case, it wouldn't be too bad since we're just displaying info. Could be a form with caption and button. You'd need to Load the user form, set value of...

Here's your code. Sub FindAndColor() Dim fCell As Range Dim firstAdd As String Dim myCount As Long 'Where are we searching With Worksheets("Sheet1").Range("D:D") 'What are we looking for? Set fCell = .Find(what:="T3RRF2", LookIn:=xlValues...

Here's a function you could use. Function LineSplit(strStart As String, lngLength As Long) Dim i As Long 'Remove any existing line breaks strStart = Replace(strStart, Chr(10), "") For i = lngLength To Len(strStart) Step lngLength + 1 strStart = Left(strStart...

Duplicate post. Please refer to your earlier thread.

I understand your concern, but my disagreement with it is that Excel doesn't really offer "security", it offers "protection" in these cases. The distinction is that the former refers to keeping files secure, and away from the wrong people. The protection that most people use in XL (sheets...

Yes, it'll unlock any VBA projects you have open at the time of running (add-ins, hidden workbooks, etc.)

We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel.

Since you've already got a filter applied in a way (you're checking for visible cell), then I'd just add another criteria to the filter to hide the cells with 0 and blank. Then it's a simpler copy & paste.

Hi trividha, You'll get more responses if you start a new thread rather than tacking onto an older one (especially one from 2015).

It acts as a counter. The COLUMNS function returns a number indicating how many columns are in the given range. So, at first, this evaluates to 1. When you copy one cell to the right, the range becomes $A1:B1, which then evaluates to 2, then 3, etc. This is so that the SMALL function is being...

Put this array formula in AC6 =IFERROR(INDEX(4:4,SMALL(IF(COUNTIF($C$7:$Q$7,$C$4:$AA$4)=0,COLUMN($C$4:$AA$4)),COLUMNS($A$1:A$1))),"") NOTE: Confirm as an array using Ctrl+Shift+Enter, not just Enter. Copy cell to the right as desired.

A quick search of our forums: https://chandoo.org/forum/threads/remove-password.23208/

@zrs As Alan has discovered, please remember in the future to post links to cross posts, as it saves everyone some time.

If 'Alfie' was in B1, you can INDEX the column you need via something like =INDEX(emp_table, , MATCH($B$1, emp_table[#Headers], 0)) Plugging that into your original formula =sumifs(INDEX(emp_table, , MATCH($B$1, emp_table[#Headers], 0)),emp_table[[Weeknum]:[Weeknum]],$A2)

I'd suggest running an Adv Filter. It's designed so that you have a data table, criteria range, and output range. You can also sepcify unique records only. It's easy enough to do manually, but if you want to use VB: https://www.contextures.com/exceladvancedfiltervba.html

Rollover chart with two series

Formula in D3: =IF(MEDIAN(D$8,$A3,$B3)=D$8,$C3,"No Estimate")

As the only way to do this would be via VBA, I'll move the thread.

Your setup is confusing. It looks like you're trying to use the labels in col A to figure out which sheet to grab, but the sheets have the non-descriptivate labels of "Data entry (7)" rather than "Data entry QBQ". IMO, I'd change the workbook design. First, get all the raw data on a single...

In the future, please remember to post links to your cross-posts. https://www.mrexcel.com/forum/excel-questions/1093994-autopopulate-column-after-dropdown.html

Hi @SharadSalvi Welcome to our forum. However, you'll get more help if you start your own thread, rather than tacking on to someone else's previously solved thread.

Welcome to the forum! Your attached file is hard to understand as it only has one sheet with info. Is that in the desired output, or how the input looks? It currently looks like the layout of a PivotTable. Please clarify what you have vs. what you want.

Note that that message is specifically there to avoid people using malicious code to send email w/o users knowing. Bypassing it could be considered annoying to some users. That said, you could get around it by either a) Just having the email be Show, rather than Send, and let user manually...

Missing commas between the arguments of AdvancedFilter. Also, line breaks need a " _" after them to show the code continues. Finally, when listing out argument names, you use ":=", not just "=". Cleaned code: Sub FilterDataraja() Sheets("Sheet1").Range("A1:L15").AdvancedFilter _...