active

This is hopefully a simple one. How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'. I'm looking to go from something like this: <tbody> Group RecordID Status ABC 0001 Active ABC 0002 Closed ABC 0003 Active DEF 0004 Active...

Hello Wizards, I thank you for any future help in advance. I have a userform with multiple comboboxes and some of them are used for the same purpose. By that I mean these comboboxes use the same dynamical named range as rowsource. I want to stop the user from duplicating a combobox twice, so...

Hello all, Here is the code for any active cell to get left connector. 'left direction l = (ActiveCell.Offset(0, -1).Left) r = (ActiveCell.Offset(0, 0).Left) t = (ActiveCell.top + ActiveCell.Offset(1, 0).top) / 2 Set con =...

Hi Is there away to display all headings without using Active Window. The following code works fine but i don't want to open and activate each sheet just to turn on Headings, as this triggers other objects like WS_Actvate etc. For Each ws In Sheets ws.Visible =...

Hi, Please can someone help me? I have this code that works fine for me when the Daily Check Sheet is active. I now need it altering so the code still looks for the same blanks cells on the Daily Check Sheet but when the sheet isn't active. Here is my code: Sub DaysandMonthsandInitials()...

Hi, I need a formula that will allow me to count the number of account Approved or Active between a date range A B Active 1/01/19 Approved 1/19/19 Active 2/10/19 Pending 2/20/19 Close 3/15/19 Thanks, Carlos

Thanks in advance for any suggestions for which feedback will be given. Is there a formula that you can put into a cell that will get the name of that file and not necessarily the active file? When I switch files, the cell changes to the active file even though the active file is a different...

Wondering if anyone can help. I want to create a user form with two active x text boxes. In box one you put a number and the second box uses a formula to change the number and display the result. For example put 2 in box one and it shows 100 in box 2. There are many other boxes on the form but...

Hello, I'm trying to control various labels on a Userform. Some of the things I want control: Change color of a button based on whether it has been clicked Is it possible to make a button visible or invisible by a macro? I have tried to use the following to accomplish this: Label56.visible...

Hello, i need some coding in VBA which can define this workbook & active workbook in any example. Thanks Amit

Hi all I can't even begin to determine how to approach what I would like to happen. Can I use a formula or should I use code? I have an Inv # in col "A" and a Description in col "I". I also have a table ("wordpercent") on a sheet "Info" with a list of words - Col "N" and a corresponding % -...

I am trying to hone a project management sheet that I am working on. Right now, I have a macro that sorts & moves rows of data to another sheet based upon a query of a columns contents...What this is for is when a job is complete, the user enters the shipper number in its "SHIP JOB" column &...

All tabs on same .xls file. Tab CurrentCases has named table with active cases, client name, contact info, follow up date, ect. Tab Outbound is working space, cell K3 references another cell so it contains the next business day. I have a drop down box on Outbound with data validation to...

Hello All, i make a simple user form to collect some data related to customers i make Frame contact 2 options call mail i need when the user select call an Text box active to write numbers only

Hi, I am trying to write data contained in a specific range from the active workbook to a new workbook and then the new workbook ought to be saved in a user specified location. I am using the following code: Dim x As Workbook Dim y As Workbook On Error Resume Next...

An Internet search turned up this expression for obtaining the name of the active sheet. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) It seems to work, but is there really nothing simpler and more straightforward?

I am making a spreadsheet that is a fortnightly timesheet. It has an active x textbox for each day in the fortnight. I want to be able to change the font size of some lines within the text boxes. Is there a simple way to do this like a button that increases the font size by 1 level with the...

What would be the equivalent of Range("C" & ActiveCell.Row) for columns? Thanks Tom

Hello, We are looking for assistance in moving data from one workbook on the network to another WB on the same Network. We currently use the code below to move data from the active workbook to Sample Request Log.xlsm. in the code below we pull data from various cells across the active sheet...

Could anyone help me with VBA for copying data from active sheet and pasting in the first available row in sheet titled Archive. I'm trying to copy Range A2:G2, paste in the first available row in Archive sheet. Then in the active sheet delete cells D2, F2 and G2.