required

Hi, I have created a user form in sheet1(Data_Entry_Form) and my data in sheet2(ICC_Data). When I run the user form through command button in sheet1. I am getting a message "run time error #424 , object required" and when I debug, it highlighted at userform1.show. When I pressed f8, it is...

Hi all Unable to sort year as required by my boss i.e. 2018, Plan, 2017 I am making pivot table with the huge data and the result required as above but when I am forting years it either giving 2017, 2018 & Plan or Plan 2018 & 2018 How can I get 2018, plan 2017 ?

Hello, I've been asked to help design a rota system but struggling with some of the more complicated formula's. I've provided a mock example but the formula required would need to search a row for the date specified, then search that dates column for the dept number and return the staff member...

I have an employee sign in sheet that after they click on the button to sign out, the cells in that row all lock so no one can edit their info after they sign. I have 4 cells that I check to make sure that they fill in before signing. My macro works great and it's exactly what I need. However...

Hello, I'm trying to create a form that cannot be printed unless certain fields are filled in (A1, B19 & B45). Been using VBA and found this online: Private Sub Workbook_BeforePrint(Cancel As Boolean) If Sheets("Cover Sheet").Range("A1,B19,B45").Value = "" Then Cancel = True...

Hello I am try to pervent excel from closeing unit the correct data is entered, what we need is if there is the word Required in any cell down the B column excel wont close and request the cell be filled out. I have a formula work if anything is entered in the D cells the corresponding b cell we...

Hello I need some help with creating a formula for the below table. What I am trying to achieve is in the "required results" column A. The "Name" entries will always have "Name" preceding <tbody> required results Name Jimmy Name Jimmy -shoes -shoes Name Tom Name Tom-Balls...

Hi All, New to the group and I have a problem that is probably very simple but it has me stumped. I have a list of names produced by some calculations. This list has spaces in it where the results mean that the name is not required (like a staff required list) I want to be able to use the list...

Sorry folks, brain has fallen out of my ear. I have a table listing "sales" per week. Table has 52 columns to represent year. Averages are generated for Q1/Q2/Q3/Q4 & YTD using the SUM/COUNTA method. If I wanted to display the weekly performance required to bring the average to a target...

Hello, I am trying to get this nested IF formula to work, however it keeps returning FALSE. Any help appreciated. =IF(D3="Monthly",IF(COUNTA(E3)<1,"Action Required",IF(D3="Hub Contact",IF(COUNTA(E3)>1,"Action Required",IF(D3="Bi-Monthly",IF(COUNTA(E3)<>E3/B1,"Action Required","No Action"))))))...

Please can someone help me, I have 2 files with the name of Schedule Jan 16, 2018 Test.xlsx and other is Report 16012018.xlsx I want to do Vlookup in the file 1 and to take the name of file 2 to get the information I required from the cell. Please see my formula VLOOKUP(L10,'G:\SS\Box\P...

Hi, I am getting an Run-time err 424 Object Required error on the line of code below. If CustomerComboBox = Application.VLookup(CustomerComboBox, InvoiceInfo.Range("NonautomatedContracts"), 1, False) Then MsgBox "Please fix." Exit Sub End If This is taking place in a...

HI, How to calculate only figure in column not figure with percentage. <tbody> Required Answer 1000 1000 2000 2000 1000 1000 100% 100% 2000 2000 100% 100% 6002 =SUBTOTAL(9,A2:a7) 6000 </tbody>

Hello, I have the below required fields code that I am using to ensure all required fields are filled before adding a record to our table. However, it is still adding the record even if I leave some of the required fields as blank. Dim msg As String, Style As Integer, Title As String Dim nl As...

Hello, I am using the below code for required fields in the form's Before Update event. For Each ctl In Me.Controls If ctl.ControlType = acTextBox Then If ctl.Tag = "*" And Trim(ctl & "") = "" Then msg = "Data Required for '" & ctl.Name & "' field!" & nl & _...

I have a database from column A to BN. Now i have only 2 rows but intent is to add data as and when received. What i want to do is to get a form for this data-set. Once the form is open i will edit the data in the form, edit it if required and the changes should be done in dataset as well...

hi friends, i create the code. automate send the wishes in outlook but i getting error run-time error 424 object required. please give me solution or any idea thanks:confused::confused:

<colgroup><col span="4"><col></colgroup><tbody> A B C D 1 bill no rate amount required sum 2 100 12 300 3 100 12 245 4 100 5 334 5 103 12 456 6 103 5 166 7 105 5 321 8 105 5 766 9 105 12 776 10 105 12 978 </tbody> <colgroup><col...

Hello, Been getting sub or function not defined when using: Outlook.Application IsAppRunning Does anyone have ideas I'm pulling my hair out, chances are it's something in tools/references but I'm confident I have what's required ticked... Luke

Is there a way to make a required cell without the use of VBA?