Search results for query: *

Thanks for that! I'll give it a go now

Hi! Little question: Does anyone know how to create and name a chart using vba? I can rename a chart but whenever i create a new one the chart name changes. Sooo has anyone worked out how to plot certain values from a table into a graph with a set name? Thanks Fez

Cool thanks for the pointer! erm but can you populate a user function with data from a userform, so it can be calculated automatically? Cheers Fez

Hi! I'm trying to develop a complicated spreadsheet which can easily be audited to ensure it's giving the right answers. Many formulas used in it are well documented. Is it possible to create user-defined functions. THen call these using VBA from within a userform or similar? Any ideas would...

Hiya! I've been asked to look into setting up an online seminar booking form so people can book onto certain courses up to the seating capacity limit of 20. Then possibly post to a website with how many spaces left on each course etc. WOuld this be possible for a relative new-by and if not does...

Hi! I have a form setup in Excel 97. One of it's functions is to input data into the spreadsheet. However when I go to the form again all the fields are clear even if I ask the form to place the values in the boxes: S1TextPlace.Text = [Place] Is there anyway I can update all these fields...

I'm sorry if this has already been covered - I couldn't find an appropriate thread. Basically the situation is this. I'm in Excel and have set up a user form which is activated with a button. There are a load of simple text fields which will get filled in. These will then be put into certain...

Hiya! I've just inherited a simple database which was originally on Foxpro. I've managed to get it into Access, however it's probably a good time to overcome some shortcomings of the old database. My problem is that for the last 10 years(!) the basis of the database has been project number...

Cheers xlbo - that's just what i was looking for! fez

Hiya! I'm trying to filter a huge excel spreadsheet so I just have a list of unique job numbers. Presently these occur in column A but could occur from one to twenty rows. Is there a filter I could put on so just the first instance of each job is shown? I'm afraid i'm out of my depth! Thanks for...

Hi! I've just started using mailmerge which is saving me loads of time! I'm presently trying to email our clients a personalised html email explaining new features of our software. It would be nice to email eveyone with the email addressed &quot;dear <name>&quot; in the same way you would with...

Hi just a quick one - does anyone know how to print a long list of file names within 98? I can go to the dos prompt but that doesn't accept long filenames. Is there a method within the GUI itself for printing bar doing loads of screen grabs in explorer? Thanks

Hiya! I've got what seems to be a simple problem, but I can't for the life of me work out how to do it. Basically I have a large table of data and i'd like to change the data from being 10 columns wide and 200 rows deep to 200 colums by 10 rows (essentially exchanging the axis) Short of a copy...

Hi! I'm just starting out in programming and it's all looking a bit complicated! I've managed to write a piece of code to process a form for a yearbook i'm compiling so each person will effectively send me a message with answers to all the different questions. Unfortunately Outlook recieves this...