Search:

Type: Posts; User: Mark@SF

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    1,141

    Working with a formula in a chart's textbox

    I have struggled with how to add a formula to a textbox in an Excel chart without having to call the Select method. After quite a bit of searching, I've found a couple of ways to do this. The...
  2. Re: Iterate attributes of PageSetup property of worksheet with Excel VBA

    Thinks for the clarification. I was able to get your code example to work.

    Do you know why some (most) of the attributes of the PageSetup property are listed twice by the DumpProperties method?
    ...
  3. Re: Iterate attributes of PageSetup property of worksheet with Excel VBA

    jdelano -

    Thanks for your reply. You mentioned...



    Is the DLL named "tblinf32dll"? Your OneDrive folder has "TLBINF32.DLL".
  4. Iterate attributes of PageSetup property of worksheet with Excel VBA

    Is it possible to iterate through the attributes of the PageSetup property of worksheet using Excel VBA?

    For example, using something like the following pseudo-code...



    For i = 0 To...
  5. VS 2019 Re: Change how data is displayed in DataGridView

    Hi paul -

    Thank you for your help. The code you suggested raises a FormatException ("Formatted value of the cell has a wrong type.").

    Here is how the DataGridViewTextBoxColumn is configured......
  6. VS 2019 Change how data is displayed in DataGridView

    I have a DataGridViewTextBoxColumn in a DataGridView that is bound to an integer-type DataColumn of a DataTable. The values range from 0 to 1200. I would like divide these values by 100 and show...
  7. Replies
    0
    Views
    514

    VS 2019 Website login automation

    I have an SQLite database application that manages websites, usernames and passwords.

    Early versions of this application included automatic website logins by searching the website's document...
  8. VS 2019 Microsoft Edge WebDriver and Windows Updates

    I have a few applications that use the Microsoft Edge WebDriver (msedgedriver.exe). The Microsoft Windows Update will occasionally install an update that will "break" these applications because the...
  9. VS 2019 Re: Formatting multi-line title of Excel chart using early binding and VB.Net

    @schoemr -

    Thank you for your helpful suggestions. The problem was the missing Microsoft Office 16.0 Object Library reference. The code below does the trick :)...


    With CType(xlChart,...
  10. VS 2019 Re: Formatting multi-line title of Excel chart using early binding and VB.Net

    @schoemr -

    I have added a reference to Microsoft Office 16.0 Object Library.

    This code compiles, but raises an System.InvalidCastException at runtime...


    With CType(xlSheet.Shapes(0),...
  11. VS 2019 Re: Formatting multi-line title of Excel chart using early binding and VB.Net

    @schoemer -

    This compiles, but raises a System.Runtime.InteropServices.COMException at runtime.


    With CType(xlSheet.Shapes(0), Excel.Shape).TextFrame
    With CType(CType(.Characters(iPos,...
  12. VS 2019 Re: Formatting multi-line title of Excel chart using early binding and VB.Net

    @schoemer -



    This line won't compile (IDE message is 'Reference required to assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c')...


    Dim titleText As...
  13. VS 2019 Re: Formatting multi-line title of Excel chart using early binding and VB.Net

    @schoemr -

    Yes, "Microsoft.Office.Interop.Excel"
  14. VS 2019 [RESOLVED] Formatting multi-line title of Excel chart using early binding and VB.Net

    I would like to change the font of the title of an Excel chart that is embedded in a worksheet. The title has 2 lines and I want to change the 2nd line's text to be Regular style and 12 point font....
  15. Re: Excel iterate AutoFilter criteria items

    I edited the code example in my earlier post #3 to show the nuiances of using a variant-type variable for the array of filter criteria values.
  16. Re: Excel iterate AutoFilter criteria items

    Zvoni - Thank you for your response. I also discovered that when there are more than 2 criteria selected, the criteria array is of type variant.


    Function GetFilterCriteria(myFilter As Filter)...
  17. [RESOLVED] Excel iterate AutoFilter criteria items

    How can I iterate the items of an AutoFilter? In this scenario, I have a column that has an AutoFilter. When the user clicks the AutoFilter icon, a menu pops and the user selects 3 items as the...
  18. VS 2019 Re: Compacting Row.HasVersion(DataRowVersion.Proposed) use?

    si -

    Thank you.
  19. VS 2019 [RESOLVED] Compacting Row.HasVersion(DataRowVersion.Proposed) use?

    Is there a way to do the following in a single statement?



    If e.Row.HasVersion(DataRowVersion.Proposed) Then
    Debug.WriteLine("Proposed = " &...
  20. VS 2019 DataViewRowState vs. RowState vs. DataRowVersion

    I need some help sorting out the differences between DataViewRowState enum vs. RowState property vs. DataRowVersion parameter. It seems like there is some overlap/redundancy in these terms. What is...
  21. VS 2019 How to create an extended StatusStrip class?

    I am trying to create custom StatusStrip class that has a few ToolStripStatusLabels. So far, I've been able to create this class (StatusStripMain). It compiles and appears in the VS Toolbox. I can...
  22. Replies
    3
    Views
    762

    VS 2019 Re: BindingNavigator behavior?

    jmc -

    Thank you. I will dig into that link.

    I am trying to modify one of my applications to improve its data validation features. This includes using the form's AutoValidate property...
  23. Replies
    3
    Views
    762

    VS 2019 Re: BindingNavigator behavior?

    Also, where are actions of the default properties of the BindingNavigator's "command" buttons (MoveFirstItem, MoveNextItem, MovePreviousItem, MoveLastItem, AddNewItem, and DeleteItem) and...
  24. Replies
    3
    Views
    762

    VS 2019 BindingNavigator behavior?

    The BindingNavigator.ItemClicked event is raised when one of the navigation buttons is clicked, but not when the PositionItem text box is clicked. I'm confused here because the PositionItem is...
  25. VS 2019 Re: Record navigation via BindingNavigator.PositionItem

    I think I've got it figured out.



    Private Sub bnMainPositionItem_Validating(sender As Object, e As CancelEventArgs) Handles bnMainPositionItem.Validating

    '...the ValidateChildern method...
  26. VS 2019 Record navigation via BindingNavigator.PositionItem

    I would like to override the standard operation of the BindingNavigator's PositionItem textbox member so that when the user types a value into the textbox I can validate the form's data before the...
  27. VS 2019 Re: Is the mouse click in a form's non-client area?

    jmc and sonic -

    Thanks. I'll go with the FormClosing event.
  28. VS 2019 Re: Is the mouse click in a form's non-client area?

    jmc -

    I tried your suggestion. The code snippet below is in a TextBox control's Validating event handler.



    If RectangleToScreen(ClientRectangle).Contains(MousePosition) Then
    '...the...
  29. Replies
    2
    Views
    740

    VS 2019 Re: BindingSource.EndEdit method

    Hi jmc -

    The background for my question is that I'm learning more about how to validate a user's data entries and reworking some code with this information.

    My form has a BindingNavigator that...
  30. VS 2019 [RESOLVED] Is the mouse click in a form's non-client area?

    My form has a textbox and the textbox has a Validating event handler. The form also has a ControlBox that includes the "X" icon to close the form.

    The Validating event fires when I click the "X"...
  31. Replies
    2
    Views
    740

    VS 2019 BindingSource.EndEdit method

    I would like to trap and handle implicit calls to the EndEdit method of a BindingSource so that I can take action before the values in data-bound controls on a from are pushed to the underlying...
  32. Replies
    1
    Views
    463

    VS 2019 Form controls not scaling properly

    I have a desktop with a 27" monitor and laptop computer with a 13" monitor. I develop my applications on the desktop computer (fullsize keyboard, large monitor, etc.). The desktop computer's...
  33. Replies
    3
    Views
    655

    Re: Using VB To Control Websites

    Hi Shaggy,

    I agree with you on the "brittleness" of the OP's code.

    Setting that aside, how does something like Apple's Safari browser perform automated user logins to a website? Wouldn't...
  34. VS 2019 Re: How to work with encrypted string data

    jmc - Thanks for the good advice.
  35. VS 2019 [RESOLVED] How to work with encrypted string data

    My application keeps its data in an SQLite database. Some of the data in the database is stored as encrypted text strings. I want to display this data as unencrypted (decrypted) text strings in a...
  36. VS 2019 DragDrop from a modal form to another form

    Is there a way to perform a drag-and-drop operation from a datagridview control on a modal form (frmTwo) to a datagridview control on another form (frmOne)? In this situation, frmTwo is opened by...
  37. Replies
    7
    Views
    1,150

    Re: Cast DataTable to get its Update method?

    The author of the CodeGuru article was David Catherman and per the below link, his extended BindingSource article was part of a four-part project.
    ...
  38. Replies
    7
    Views
    1,150

    Re: Cast DataTable to get its Update method?

    paul and shaggy -

    I know my question is a weird one because it's about code that I didn't write. But, the example that is in the referenced link is very interesting. It was published on the...
  39. Replies
    7
    Views
    1,150

    Cast DataTable to get its Update method?

    I came across an article (with code) that described how to extend a BindingSource component to add some useful features.
    ...
  40. Replies
    16
    Views
    2,274

    Re: PrintCommunication COM error

    At this point, I'm leaving in the PrintCommunications = False statements and leaving out the PrintCommunications = True statements. The code runs without raising any errors and the PageSetup...
Results 1 to 40 of 487
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width