Answer Questions

• homeslick Excel VB problem

  Hi, I am a new VB user and I need some help. I have a worksheet with a combo box that references a list of items on another worksheet. See my code: Private Sub ComboBox1_Change() Worksheets("Sheet1").Range("A11").Value = Me.ComboBox1.Column(0) Worksheets("Sheet1").Range("B11").Value = Me.ComboBox1.Column(1) Worksheets("Sheet1").Range("C11").Value = Me.ComboBox1.Column(2) ...Show All

• hlubertus Word: Normal.dot template menu bar

  I have programmatically modified the Normal.dot menubar (adding more dummy options), and I want to get rid of all of them, permanently, to return to the original state and appearance of Normal. dot.... How can I achieve that, please thanks Hi Brenda I tried your workround solution alas it did not work. I am certain that the normal.dot file is not being created as I can find no reference to it when I do a search. ...Show All

• Andy Lowen code in visual basic to convert decimal to hexadecimal and vise versa

  i need help to write code for visual basic to convert convert decimal to hexadecimal and vise versa can anyone help This is from methods in VBA but they should be in VB. The Hex(number) method returns a string representing the hexadecimal of the number. It only works with whole numbers in VBA, it should be the same in VB. There is no hexadecimal value for 10.45. See what the help file says about the method. To convert hex to n ...Show All

• Ravin08 your view on product roadmaps

  I'm curious to find out what your views are on product roadmaps... 1. Valuable or not 2. What is more important - being able to see the product integration or the estimated timelines or both 3. If you currently work with a product roadmap, what format do you find most useful - interactive/online, PDF, other Textual display or visual thanks, -brenda (ISV Buddy Team) We are a very small ISV too. We are currently d ...Show All

• Yury P New to VB

  I have to do a project in VB Excel. I don't write code and it has been over 10 years since I took any programming classes. I have books on VB but I don't know where to start. I need to have our main invoice spredsheet update automatically when we get new invoices at the end of the month from our printing service. I know what I want to do but not how to code it. I would appreciate any advice. Thanks, Melissa ...Show All

• Orman VB in Excel Macros versus VB Express

  In working with Excel in Office 2003 I see that macros have the title "Microsoft Visual Basic" Which version of Visual Basic is this Also, is this Visual Basic a fully featured one more so than the Visual Basic Express 2005 edition that is available for download free I am asking because I am finding that the transfer from VBE 2005 to Visual Basic in Excel is not that straightforward. ...Show All

• Seppe001 MS Word Option Button Collection

  Hi, I am trying to use option buttons from the control toolbox in a word document. I have set the groupname and they work fine but.... I then need to loop through the option button values in the group and I can not work out how to create the array or collection - I have tried the shapes property and the inlineshapes property of the active document but they have not worked. I need code a bit alike below: dim optBtn as msforms.optionbutton for ea ...Show All

• PiperPilot What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• Gabriel Mendez Subform Problem

  hi all i have a problem that i tried my best to solve it but i can 't till now the problem is i have a form with 2 sub forms in side it built using MS access 2000 currently we moved the database from MS access to MS Sql Server 2000 since then this form no longer works the form idea is that user select the customer id from combo box after update event will do requery for both subforms both sub forms based in a query th ...Show All

• rivast_2001 VBA Visio 2002 and OpenEx

  Has anybody else experienced that the flag argument to the Documents.OpenEx method have no effect in Visio 2002 I try : Call Documents.OpenEx(FileName:=MyFileName, Flags:=vizOpenDontList + vizOpenMinimized) But I see that the Visio document opens maximized and it also appears in the history list. What am I doing wrong (I see that the Object Browser calls the argument Flags , while the help file calls it openFlags ) Thanks in adv ...Show All

• Am X read-only OLEs ?

  Hello all ! I 'm database administrator and I 've a MSAccess db , which contains a tables with OLE objects (most of them are MSWord documents). I 've also some forms , that prevents they fields from changing (read-only forms). But when OLE object field is "executed" (Word document opens) , user can modify something. Then , when user closes form , he is getting an error with saving OLE object. Question: how to prevent OLE object from ...Show All

• SteveChick Defining a range according to the number of responses

  Dear all, I'm a new user of Visual Basic (version 6.3) and need to write a Macro for use in Excel. I need the Macro to calculate Rank values for an unpredictable number of scores. The number of scores that need to be Ranked will vary and I don't know how to incorporate this variation into the Visual Basic Macro. In my current spreadsheet there are 11 scores (Sorted in descending order) in column DS (cells DS2:DS12). The Visual Basic cod ...Show All

• intech27508 Absolute Links in Excel

  Hi all, I need help in excel, regarding to Hyperlinks. I have a spreadsheet with a long list of Hyperlinks to different files. Excel inserts hyperlink in a relative mode by default. As a result, the data in the address field is relative data. I need to know the full path of all the files inserted in the spreadsheet. I will present this data in the TextToDisplay Field. I didn't put any screen tips, so the default screen tip shows the fu ...Show All

• zoid form-Subform

  Hi, I'm facing problem with a subform and form. I've a parent form which has only one control which is a combo box. the recordsource is valuelist n it has got week day names in it..monday-friday i've got 3 tables A, B, C..... C is the table having primary keys of A & B as forieng key so its a A(1)->C(m) & B(1)->C(m) relation table c has a field storing commencement date of term as date type. let me be more specific.... table A Cla ...Show All

• Selven partly remove the code from VBComponents

  I wanna use VBComponents.remove to remove part of the code from one function workbook_open(). Is that possible See waht you can get from Chip Pearson's site ...Show All