Do you mean the icons on the top bar containing the favorites icon, history icon...etc? Or do you mean a new toolbar like google toolbar kind of thing?

I wondered if anyone may know, I just want to write a bit of VBA to put in an excel macro so that it a sheet of data, wherever a row contains a 0 in a certain column (e.g. column e), the row will be deleted. I know it would be a loop but I have never been very good on loops. So basically, e.g. it would do this Row(2)- if cell E(2) = 0 delete row, search next row, search until rows are null thanks

I wondered if anyone could help. I want to write a script in a page to show the days since a certain date (which I would hard code into the script), so for example, on the screen it would show: "It has been xx days since this event" (where xx is the number of days) How would I do this, I could imagine it would be quite an easy javascript snipet using the dateadd function but I was not sure and couldnt find much on google to help. p.s. Currently using HTML on the page but am I write in thinking a snipet can be any language as it is just declared at the top of the snipet and closed at the end? Thanks

All I want to do is create a VBA script in Excel 2003 where I search through a spreadsheet, and delete every row where column E in the row (a date and time field) does not contain the text 2008. So e.g. If E1 contains 2008 delete row 1 If E2 does not contain 2008 keep this row (row 2) If E3 contains 2008 delete row 3 Continue until no more values How would I do this please? I have tried to do it using in built features on Excel but i can only find and replace...etc and the macro recording isnt really helping much hense why i am asking for your help. Thanks:confused:

modified on Tuesday, May 13, 2008 5:23 AM

Hi, I need some help with a VBA script in Excel 2003, its probably really simple but the macro recorder hasnt been much use and im not sure how to start. All I want to do is: Check a worksheet value (i.e. in call A1), for the first value check on another worksheet list >> If this value is in a row, delete this row and all rows containing this value, if not, do nothing and check the next record Then move onto the next record (i.e. in cell C2) until there are no records left to check How would I do this please (or can you give me advise on how to do something similar so I can make a start at finding a solution?). Many thanks in advance

I am not sure what you mean, you want to stop it running anywhere apart from the schools where it is installed, if so I think this is going to be hard, unless you put like a hidden authorisation file on each computer it is used on?

Change it in the project properties, it can dictate which folder the files are stored in, and you can set where you want the compiler to output the debug and exe files

Cant you just lock the objects, which would stop them moving (I remember reading something about this?? Also, is it are you going up or down res, or both?

I am trying to do this loop, so it checks if a value entered is present, if not, it deletes the row, however, the process hangs once it finishes, how do i end the statement (i.e. when all records have been checked, display a message box), as I am not sure where to end it (I thought the end if and wend would end the statement, but do I possibly need an else somewhere?), cheers p.s. this is VBA in excel 2003, but I assume its the same principal as VB ---- 'When a cell contains data, perform the IF... While Len(Range("B" & CStr(LFindRow)).Value) > 0 'If the cell does not contain the inputted criteria then delete the row If Range("B" & CStr(LFindRow)).Value <> CustVar Then Rows(CStr(LFindRow)).Delete 'End the IF End If 'End/Loop the while Wend ----

I could not find a VBA forum on here so figure this is the closest forum. I have an excel doucment, here is kinda what I want to do: - I have a value entered from an input box (Y), i want to - If Column A (X (would start at 1)) contains (Y) then Highlight (or select whatever it is) - Make x + 1 to go onto the next row to check - Loop until end to ensure all records are checked - Copy the selected files (already sorted this bit) This is probably really simple but im new to VBA, help! Cheers

Does anyone know a good link to some source code for a world clock, or at least, a clock application. I wanted to see how it works, then change it quite a lot for my own use (and before anyone says anything, no this is not homework or going to be used for anything dodgy). Cheers

Dont worry, i am just trying out code really, not copying and pasting and leaving it that way. Still, what is the "not me" bit about?

is this the exact code i should use? I have tried it and i get how it works, but i am getting an error on "not me" bit, and why is there 2 nexts, wouldnt one just create the loop?!

The aim is to make a goodbye screen, but at the mo it is just over the top of the current form, whereas i want that to be the only form shown! I will have a go with this statement

What do you mean, application.exit.... something??? Im not a wiz at vb by the way, just a beginner!

Is there a way in VB.NET 2005 to close all forms (or hide) except the one that is being loaded, without typing a load of code to hide each form? Cheers

Hi, sorry, forgot to mention, its for VB.NET 2005. How does the mark edit control work? I have looked on MSDN but it doestn really help. I guess its nothing like excel's input mask!?

Is there are a way to put an input mask or some type of validation on a text box? I either want to stop anything apart from upper and lowercase letters as they are typing in the box or Load an event on a button press if anything except uppercase and lowercase is in the box. Any ideas? Cheers in advance

All i want it in is for the taskbar, where can i do this?

In Visual Studio (VB.NET) 2005 simple as the title says, how do i keep the program name, but get rid of the top bar, i have deleted the control box, but when i put form text in, the top bar comes back!!!