Posts by royUK

Mats is right, this addin is great. 300+ extra functions for Excel.

Look at the Columns/Rows submenu

John Walkenbach demonstrates how to use Conditional formatting to achieve this here;

http://j-walk.com/ss/excel/usertips/tip043.htm

I have an addin downloaded from Aaron Bloods's site Ledger.zip

http://www.xl-logic.com/pages/addins.html

Hi

I have changed the name 004, hope it was an error caused by the download. If need be I will email it to you from home tonight ( I am at work now and I don't like to use company email)

Roy

I have used the same example and entered nother two bookings, again with no error messages.

I fill in the required data in the Invoice form and use the button to post it to the bookings. When I open the bookings sheet the list is sorted automatically.

I cannot duplicate your error message at all. Try downloading again perhaps.

Roy

Which version are you using. Post it up and Iwill try it out.

Roy

Hello

I have just entered another invoice on example003.xls and it posts to bookings and sorts the new one by order number to the top of the table.

I had no error messages

Roy

i am only guessing but it might be caused by the hyphen. Hopefully, some one might know for definite

In example 003 I have placed the sort macro in the workbook_activate event of the bookings sheetso that it sorts when this sheet is opened.It also now sorts by Order number, the latest first.

Check out Dave hawley's downloadable Tutorials on this site

Only with XP. If you have it's in the fromat menu

I have played around a little more and I think it is doing what you wanted.

The invoice numbers are sorted when the bookings sheet is activated with the newest number going to the top.

check this one

Roy

Your clear macro was deleting the order number, I have fixed that.

I have added another macro to sort your orders by date, newest first. I have created a dynamic named range (database) for your data

Have you named the cell where you have your invoice number -"InvNo" ?

I have had alook at your example. basically you need to name the cells that you want to save. Here's the code that saves the data to your summary sheet. Also the one to clear the contents.

Name your ranges as and change the names in the code to yours. Then paste the code into a macro and assign it to your button.

Check this solution out. I think it covers everything

http://ozgrid.com/forum/viewthread.php?tid=960

Roy

easiest way is to use Data_Validation and then in the form choose list and in the Source box select the list you want to pick from.

To use a list in a different sheet, first name the range and again select List in the Data Validation form and in the Source box type =YourRange

Try this, I haven't fully tested it yet but it should do what you want

Use the Worksheet_Activate event, Right click on the sheet tab and choose view code, oo the left hand dropdown select Worksheet and using the right hand one find and select Activate.

Private Sub Worksheet_Activate()
YourForm.Show
End Sub

Now whenever you open this sheet your form will open.

I am not sure about your second question.

Change your Mood in your User Profile

:cheers:Roy

Hi

Here's my son's spreadsheet for multiplication. I added this Splash Screen to amuse him.

I am sure there are other posts about this on the site and that there is anarticle somewhere on the Ozgrid site.

An alternative would be to have all sheets hidden except one with your splash screen and a VBA timer to hide it and open the other sheets