Search results

Thanks for your time SirJB7. The LoadFactor matrix is not constant. It contains any contiguous range as my load cases could go up to 25 and load combinations up to 2000 for a typical structure that I work on. I am looking for something like this. I tried this from one of the other forums...

a) It is a contiguous range within C6:O24 b) c) d) I programmed such a way that it picks the start row & columns and end row & columns of the matrix chosen at a). So it is quick to select the whole column for b) and whole rows for c) and d) rather than selecting the associated range. It works...

Hi SirJB7, going in detail about what I am actually after. This VBA is used to create one or two additional worksheets in which a syntax or code is produced, which can be copied to a software editor for a structural analysis purpose (I am a Civil Engineer). I have checked this code and it...

Another question: 4. When I check the validity of the range and gets the cursor back to that RefEdit using SetFocus, I want to see the associated picture in the Image. How do I do that?

Hi SirJB7, this is the link of the file, https://dl.dropbox.com/u/97890138/LoadComb%20Macro%2014%20August%202012-Upload.xlsm Please ignore my code. If the value of the range is either nil or invalid string is considered as invalid. For example, a valid string is Sheet1!$C$6:$O$24 and invalid...

I worked out for Question #1. Created more Image controls with corresponding pictures embedded in them and making others not visible except the associated one when I click the that RefEdit

I have actually two questions: 1. I have an userform with few RefEdit (Form) controls, an Image (Form) control and a Command Button (Form) control. I have set different images when I click different RefEdits using Image1.Picture = LoadPicture("D:Documents and...

Thank you!!!

How do I get the cell values of the selected range using RefEdit control in Excel 2007? I have a RefEdit control in an userform, used to select a range in a worksheet and want to use the cell values for my further calculations. Wondering how I get these values.

Thanks Hui. I have unlocked only a certain range of cells as my data in those cells is an output from a software program which would be in a standard (text) format all the time - Hari

Sorry I should have given a bit more explanation regarding my query. I am the originator of the protected spreasheet and I want to allow users to do "Text to Columns" only for a certain (unlocked) cells in that sheet keeping all other (locked) cells protected. Let me know if I am still not clear...

How do I make "Text to Columns" option active with a password protected worksheet in Excel 2007?

Sorry, my mistake, there were two worksheets with the same name (not really, the other sheet with a little extension). With the windows/frames in VB Editor showing only first half of the sheet names, I had the code in other sheet. Thanks once again Hari

Excellent, thank you very much Narayan. I don't know why this code is NOT working for one worksheet (in the same workbook) only which I made a copy from another workbook. It works perfectly for other worksheets though. That's not a big issue as my purpose is served mainly with other...

Something similar to the FIGURE shown in the link below, bottom of the page http://www.aspose.com/docs/display/cellsnet/Activating+Sheets+and+Making+an+Active+Cell+in+the+Worksheet

Thanks Narayan for your reply. No, this is not I was looking for. I want to show the part of worksheet starting from a specific row every time I select/click/activate (not sure which is an appropriate word) on that worksheet. For example, in a workbook of 3 sheets, when I click on Sheet2 I...

I am trying to set a first visible row in each worksheet in a workbook when I switch between the worksheets. How to do it? Please advice.