Search:
Type: Posts; User: Mark@SF
Search:
Search took 0.15 seconds.
-
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...
-
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?
...
-
jdelano -
Thanks for your reply. You mentioned...
Is the DLL named "tblinf32dll"? Your OneDrive folder has "TLBINF32.DLL".
-
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...
-
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......
-
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...
-
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...
-
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...
-
@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,...
-
@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),...
-
@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,...
-
@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...
-
@schoemr -
Yes, "Microsoft.Office.Interop.Excel"
-
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....
-
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.
-
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)...
-
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...
-
-
Is there a way to do the following in a single statement?
If e.Row.HasVersion(DataRowVersion.Proposed) Then
Debug.WriteLine("Proposed = " &...
-
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...
-
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...
-
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...
-
Also, where are actions of the default properties of the BindingNavigator's "command" buttons (MoveFirstItem, MoveNextItem, MovePreviousItem, MoveLastItem, AddNewItem, and DeleteItem) and...
-
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...
-
I think I've got it figured out.
Private Sub bnMainPositionItem_Validating(sender As Object, e As CancelEventArgs) Handles bnMainPositionItem.Validating
'...the ValidateChildern method...
-
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...
-
jmc and sonic -
Thanks. I'll go with the FormClosing event.
-
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...
-
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...
-
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"...
-
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...
-
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...
-
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...
-
jmc - Thanks for the good advice.
-
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...
-
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...
-
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.
...
-
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...
-
I came across an article (with code) that described how to extend a BindingSource component to add some useful features.
...
-
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...
|
Click Here to Expand Forum to Full Width
|