Recent content by Epsilon101

Ah nvm, done it. Autofilter on 'OUT' selected the accountID's. Did a vlookup check formula on the results and kept any that gave an error value. Thanks for your previous suggestion that helped. --------------------------------------- Neil

Sorry my mistake i used the wrong bit of code above. I dont want to delete blanks mainly cos i dont have any. Ive got 9000 rows , but easiest way to explain would be 1 account with 10 transactions on it So 10 rows the accountID is the same on each row, but the trans code can change. If a...

Hi, This is in Excel. I have got some rows of transactions. There is an ID number for the accounts in column A and a code for the transaction type in column C. I am trying to do something in vba or with formulae, but its proving difficult. The idea is to check column C, if the transaction...

if you want the button to run a function that is in a different location and is private, try putting the function in a separate module and using Call. The below is another way where the module1 contains the function IsNothing. Then you can use IsNothing() in another sub or function eg. If...

so have to add the % at the end to get it to work.. As my users will never bother with that and just type 21.9 ill have to divide by 100 after update. --------------------------------------- Neil

Hi, I have got a table with a field for percentages It is set to: Data type: Number Field size: Double Format: Percent Decimal places: 2 On my form the text box is: format: percent Decimal places: 2 What i want to do is instead of having 21.9 come out as 2190% when you type it in the text...

Ah thanks for that one Great help --------------------------------------- Neil

Hi, i have got a form made from a table called TblMain. Each record has a date field for date entered. I have made a field in TblMain to hold the week commenced date. Just need to figure out how to have a working calculated field in the form so that the calculation saves in tblmain. The...

Ah thanks i get you now, its just me thinking of [COLOR=blue]Application.SheetsInNewWorkbook[/color blue] acting the same as a variable, when i know it isnt. Thanks for the explanation to clear that up --------------------------------------- Neil

Thanks for checking it Tony. Did you mean this bit? 'position of the last name in list = iNewSheets integer Application.SheetsInNewWorkbook = iNewSheets Didnt Application.SheetsInNewWorkbook equal the last row that contains a cell of data in column A. So last name is in cell A4 it goes to...

Ah cool thanks Tony, the sheetsInNewWorkbook property is handy to know. Here is what ive got after reading through it, please correct me if im wrong. Sub NewBook() Dim objSheet As Worksheet [COLOR=green]'XXXX Dont need this set, is done below XXXX[/color green] Set objSheet = ActiveSheet...

Hi, I am trying to do the below: Have a macro that will create a new workbook, with new sheets, amounts and names of which are dependant on a list in column A. So A1 = Menu A2 = User A3 = Data which will create a new workbook with 3 worksheets in it called 'menu' 'user' and 'data'. I have...

Here we go, this is what ive got for these 2 command buttons. So now it unprotects adds the info to the sheet clears listbox, sorts it with the new info and then protects it again, as you can see below. All because of a bleeding . Thanks Private Sub cmdAdd_Click() With ws...

Hiya Loomah, sorry about the error, i got it at home last night and i didnt have time to re-test this morning so couldnt remember what it said. Thanks for your help on this. There is something else on this you might be interested in making even better. There is an error if the data going on to...

Hi, Spot of bother with this, can anyone help? its in Excel. I have a userform called FrmMaintenance. It has 4 option buttons: OptTitle OptPassed OptAbility OptReason A textbox: TxtAdd A Listbox: Listbox1 3 buttons: CmdAdd CmdDelete CmdOk The idea of it is, the option buttons update the...