Search results for query: *

Hi, ideas for this one are appreciated. I have a worksheet with several images on it (gifs pasted onto the worksheet). When a userform is opened I would like a random one of these images to be used as the image on an image control on a userform. Can easily select a random image from the...

Would anybody know a slick way to sort a collection or array into a random order? The only method I can think of at the moment is to put the values into a worksheet, assign random numbers to the next column, sort and reload into the collection/array. Yuk

Not sure if this can be done using XL2k. Would like to have a stacked bar chart with a line as well. I am able to combine bar chart and line chart but not have stacked bars. The stack bars will be the achieved volumes of business broken down into categories by month, and the line represents...

I have put together a spreadsheet which has been placed on an Intranet. The spreadsheet is therefore opened as Excel, but through an Explorer window. For some reason though when opened through this window the macros don't run properly. There is an error every time you do something using the...

Hi All I have about 9000 rows of data that refresh from an external source. After a refresh I need to add another column to the data. If one column in the data is equal to one of about 20 values then the new column has the value true, otherwise it is false. What is the quickest way of...

I am taking data from textboxes to fill cells. The textboxes have Enterkeybehaviour and multiline set to true. The problem is when the values from the textboxes are put into a cell in Excel they contain a little square () where the returns were. How can I stop these little squares showing in...

Hello all. I have previously password protected code using the VBA Project properties. However this is not particularly secure as the password can be attacked by running every combination through it, and there are of course the companies on the internet that specialise in password breaking...

1) I want to send Ctrl Alt and Delete then "W" to lock the workstation in an Excel Macro using the SendKeys action. However this does not work as it sends the keys to Excel and not the machine. Anyone know any ways around this? 2) It is possible to get any symbol by pressing Alt...

I have a workbook containing several sheets, all of which have the same Worksheet_SelectionChange event. (The events only run when certain columns and rows are selected.) I want this event to also apply on new sheets added by the user by pressing a button. This sheet adding macro, as well as...

Has anyone written a procedure to automatically sort the tab order on a userform (i.e. starting with the top left control and ordering them across then down. This would be useful to run on every userform in a project when you have finished with it to ensure the user doesn't end up tabbing all...