Search results for query: *

Hi all, in an excel sheet I have made the following: A dblclick event shows a userform. The userform picks up values from cells in the same row where the activecell is (where the dblclick is made). Now I want to have a commandbutton in the userform that clears the userform and pick up value from...

Hi all I have a weird problem with TOC The following (simplified) code put a TC field and make a TOC from that: Private Sub TabCon() Selection.HomeKey unit:=wdStory ActiveDocument.TablesOfContents.MarkEntry Range:=Selection.Range, _ Entry:="text1" & Chr(9) & "text2" &...

Hi all: How do I change the size of a checkbox, and by that I mean the size of the (little) square box, where you do the checking. If I change the fontsize it´s a bit odd that the checkbox remains the same (little) size. Hope for an answer Regards Claus

Hi all, I need some help. Problem: I have written a code in a Excel97 worksheet, which calls Word97. This have been working for half a year on daily use. Now some users have new versions installed: Excel 2002 and Word 2002. When used from Excel 2002 (works out fine) and properly saved (part of...

Hi all, in a VBA code I am sorting data: objWorksheet.Range("A8:F250").Sort _ Key1:=objWorksheet.Range("A8"), _ Order1:=xlAscending, _ Header:=xlNo, _ OrderCustom:=6, _ MatchCase:=False, _ Orientation:=xlTopToBottom The CustomOrder:=6 prescribe sort-order to be: 1Z1 1Z2...

Help ! Problem: I want to replace a block (OldTitleblock) that have attribute (OldTagValue), with another (NewTitleblock) and transfer the attribute to NewTagValue. The OldTitleblock have Tag which value shall be transfered to another Tag in the NewTitleblock. I think it should be easy done...