Search results for query: *

Penguin Further to what Ilses had to say try this to insert numbers ascending into column "A". Range("a1").End(xlDown).Offset(0, 0).Select 'last cell in the column which has a value c = ActiveCell.Value Range("a1").End(xlDown).Offset(1, 0).Select ' find...

Hi Chance1234 Please forgive my ignorance but how do you plot the average as a line Thanx Dasi

Hi I have values in a worksheet which are shown on a chart in another worksheet. The values are sales figures for each month of the year to date. If 5 months have been recorded then an average is obtained and I have inserted an average line onto the chart-manually. Is it possible that the...

Is it possible to match the choice from a drop-down box to insert a corresponding field(matching field) in a text box when I choose from a dropdown box. In excel this is possible but I do not know how to achiev this in word. If someone can point me in the direction I would be extremely grateful...

I am creating a form and mostly using the buttons from the forms toolbar. However I want to use the spin and option buttons in various groups. I know how to create userforms and to show the form. However when I mix the both I cannot access the userform when I protect the form, as this is the...

Hi I have created a form with text boxes and pull down lists and successfully saved the file as a template file (*.dot). However when I fill the form and want to save as a document file (*.doc) the dialog box for choice of file types to save is greyed out. How can I get this to work? Thanx...

Is it possible to link the resultant value of a cell to a particular jpeg file. What I mean is say a value of 1 to 5 will place a photographic image on a worksheet and other ranges( say 6 to 10) will reurn other images. If this is possible how can I do this. Please consider my lack of any VBA...

DarkSun: How about posting the code and solution on this forum. I am learning to to code and have found this forum to be my best teacher. I look forward to reading the posts and generally try to understand the various code with solutions- not always successful though. Thank you for your...

Hi Mongooses Thanx for your solution. It appears you can indeed get this to happen with the ToolTipText, BUT only when you use this with any of the control buttons in the UserForm environment. As I have already created the workbook with several macro buttons from the Forms environment I need...

Hi Is it possible to get commentary to be revealed when the cursor is passed over a macro button from a form. Please note that I do not mean the comment got from the Insert/Comment menu. I am using Excel 2000. Thanx for your help. Regards Dasi

Hi I am new to VBA. I am using a listbox to call up info from another worksheet. All this works well, BUT I need to display bold fonts and background colour to certain fields. Is this possible? Thank you for any help or pointing me in the right direction. Regards Dasi