| Thread | Last Post | Replies |
|
| Cell is locked but still editable... | 30 Mar 2006 14:00 GMT | 2 |
i am writing an Excel Addin, that retrives data from server and shows it on a pre defined template. i am trying to lock a spesific cell, according to data i retrived from my server.
|
| signal for incoming mails in outlook express | 30 Mar 2006 13:59 GMT | 1 |
hello, is there a way to get an signal( ex: a voice) when a mail from people comes to inbox using outlook express. thanks.
|
| Populating combobox in custom toolbar | 30 Mar 2006 13:48 GMT | 6 |
I have: (1) a custom toolbar, represented by the object variable objJourneyBar (2) added a combobox control (msoControlComboBox) represented by the object variable objJourneyDepartCBox
|
| Change Event Range Help | 30 Mar 2006 13:30 GMT | 3 |
I need a change event macro that fires any time there is a change on the range G11:G30. I need to the macro to take the name in the G column and make it the name of the 4 cells directly to the right (H-K). If someone can figure out how to do that for me that would be great.
|
| Converting Numeric Columns to Excel Alpha Notation | 30 Mar 2006 13:27 GMT | 5 |
Hi gurus! I need to use column numbers in a loop and convert them to the column letters for populating cells. I initially wrote a conversion function but found it failing in transition
|
| Question from A Newbie | 30 Mar 2006 13:09 GMT | 3 |
I currently have a Workbook that has 32 different worksheets. Here is my goal for this workbook and I'm hoping someone out there would be able to explain how I would accomplish it. I am new to this whole concept. I have no knowledge of VBA or programming with excel. I do
|
| Groups of controls | 30 Mar 2006 11:56 GMT | 7 |
I use different groups of controls in an excel sheet. Each time a control in one group is clicked, I would like the controls of the other groups to turn to "False". I know how to code it control after control, but this is quite tedious!
|
| difference Close and Nothing in query | 30 Mar 2006 11:52 GMT | 1 |
for example dim db as dao.database .... ....
|
| GetObject with Password | 30 Mar 2006 11:51 GMT | 7 |
Bonjour from Paris (FRANCE), It's a sunny day, today. How can add passwords (Password and WriteResPassword) to a GetObject function used to open an Excel Workbook ?
|
| conditional calculating | 30 Mar 2006 11:10 GMT | 2 |
i have 2 calcualte the diffrence from 2 rows and a constant example b1-a1 -TIME(8;30;0) example
|
| moving data | 30 Mar 2006 10:52 GMT | 5 |
hi I am looking to move data from one cell to another...I have been movin some of the date with cut and paste...takes so long... Basically want to move a list of company names and address so that eac
|
| Loop every 26 rows and if.. | 30 Mar 2006 10:52 GMT | 4 |
Would appeciate VBA code for a macro that does the following: My range from Row 2 to Row 4993 has records in sets of 26 rows each. Procedure:If Activecell (R2, Range name “Start”)=0,move 16 columns left to be at B2, write “A/C closed”
|
| I need data to copy to the next available cell in a column from a macro | 30 Mar 2006 09:40 GMT | 2 |
TIA - I've got a macro that will find solutions to a math problem. The same macro runs several for/next loops searching for numbers that match criteria for solutions. Most of these loops find multiple solutions.
|
| Does anybody have code to do this? | 30 Mar 2006 09:36 GMT | 10 |
I dont know how to explain this so here is the example. This contains 2 lists. List1 is column A&B unique ID in A. List2 is column C&D unique ID in B.
|
| Macro - save_file | 30 Mar 2006 09:26 GMT | 4 |
I have problems finding out what`s wrong with my code. Could someone help me solve my problem. I think is something to do with "Thisfile". Thanks. Sub Save_workbook()
|