modify

Hi All, on my Login Register my modify was working fine, until i got my duplicate validation working. now when i try to modify (edit) its registering it as a duplicate and it wont allow me to do it. Username is my unique column which the validation looks at. e.g employee "marpol" currently has...

I would be grateful for any help with the following problem. I have built a userform to help with inputting data for a research project due to the number of variables involved and to allow for comparison of data at the time of input. By following guides I have built a form that works well and...

Hello everybody, I am currently looking at excel/PowerPoint, where you have the following when you open a document: In the cases above, I have simply opened a blank document. However, what annoys me is that if I use a template from any prior documents, it will say the names of the authors...

Hi, First time posting a thread, long time user/reader of threads. I need help solving a problem that I can't find the answer (or close to the answer) to. What I want to do: Given a table of data which includes Part number, quote date, quantity, price and supplier, I want iterate through the...

Hi I've recorded a macro which filters blanks in a sheet. However, I need to modify it, so that it deletes the blanks from the range in the sheet regardless of the number of rows. Does anyone know how to modify the code below, please? Also, is there a good tutorial on VBA autofilters that...

I have code that checks a table to see if the Current User should be able to open a form Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler If Nz(DLookup("UserName", "tbl_Users", _ "[Object_Name]='" & Me.Name & "' AND [UserName]='" & CurrentUser()...

Good morning everyone, I hope someone can helps with this one, I have the following formula(copied down through rows etc) =IF(D2=G2,"ok",IF(D2>G2,"Supplier MPQ higher","Check pack multiple")) to return a simple text answer, but what I wish to modify this (if possible) to show that t if G2 is...

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P Q R S T U V W X...

I have a worksheet that will most likely be used by two people (a couple) but could also be used by a 'single' (unmarried) individual. I'll try to explain my conundrum. Here goes... The worksheet contains a cell with the following formula and it works as intended but I would like to modify it...

I found this - - Worksheets(“Sheet1”).Range(“RowNumber1:RowNumber2”).EntireRow.Hidden = True - - and would work, but would have to modify it each time based on the worksheet I'm in. Yes, right-clicking is easy, but when there are hundreds or, and a couple of times, thousands, no so much. Is it...

Hello everyone I have a GETPIVOT Data formula in A8 =GETPIVOTDATA("[Measures].[Name]",Total!$A$1,"[ValuesTable].[Employee ID]","[ValuesTable].[Employee ID].&[A0107733814033]") But this doesn't increment because of the ID written so i've tried to modify it to...

Hi everyone, can i post a thread present in another forum? jc

hello i like to have help with vba codes : i have a listbox in userform4 i like to add a code to use right click to modify record using userform1 (userfrom1 is used to add new data to list) and to do right click on mouse to delete selected record from list please see file and original post...

Hi, i have this table and this formula, =INDEX(Sheet1!D2:D4,MATCH(Sheet1!C2,Sheet1!C2:C4,0)*MATCH(Sheet1!A2,Sheet1!A2:A4,0)) <tbody> ID DESC A/C # AMT 133888 VOICE 8883 545 100300 IP 9833 800 100358 INTERNET #N/A </tbody> how can modify it that if a/c # is blank still get the amount...

request for help, modify the macro to the values 3333333 = 7 so the example macrode below is at 444444 ie 6 boxes, the request is to modify for seven houses up to 3 then it will be 0000000- 3333333 = 7 positions 0000000 0000001 0000002 0000003 0000011 ...... 3333333 cannot have...

I have a code that loads a value into 2 text boxes when you choose a part # in t lit box. I would like to modify the code so that it sees the part #in the list box and loads the text box, instead of upon selection of the part #. Can someone shoe me how to make the modification? Private Sub...

Sheets("Sheet1").UsedRange Dim Rng1 As Range For Each Rng1 In Range("Z:Z").SpecialCells(xlBlanks).Areas Intersect(Rng1.EntireRow, Range("A:BT")).Delete shift:=xlUp Next Rng1 ok so I have used this code many times but need to modify it a little...

I am using this code which works fine to restrict selection of one cell in a sheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Range("A1").Select Application.CutCopyMode = False End Sub However, I need to modify this so that the restriction only applies to...

I have the following code in Thisworkbook in the VBA module. I would like to copy this code onto a specific sheet but not sure how to modify it. I think I would need to change the third line to the name of the sheet. Private Sub Workbook_Open() Dim sh As Worksheet For Each sh In...

hi all.. i have following problem to modify this formula...