In WPF i've added a DataGrid:
<DataGrid x:Name="dataGridProdotti" HorizontalAlignment="Left" Margin="10,56,0,0" VerticalAlignment="Top" Height="250" Width="426" SelectionChanged="dataGridProdotti_SelectionChanged" IsReadOnly="False"/>
with the property
IsReadOnly="False"
Then i do:
dataGri...
You have:
Dim RangeNOut as Double
Dim RangeNOut as Integer
While the IF statements in there are a nice idea, VBA will not allow you to do that. It doesn't do conditional 'compilation' since it isn't a compiled language. When VBA runs your code, all your variables are declared (no matter where ...
Well, my answer is about 99.9% correct then. He can't do it the way he wants, but I had no idea you could do conditional compilation in VBA! Kinda nifty.
I'm at a mere 80 SO points today. Would be 95 if some goober hadn't un-checked my answer, then pasted in my code and checked his own answer... :/
In response to this question I thought it would be fun to write a VBE macro that would automatically replace lines which look like
DimAll a, b, c, d As Integer
by
Dim a As Integer, b As Integer, c As Integer, d As Integer
In my first draft I just want to modify a single selected line. After...
@RubberDuck This was mostly proof of concept. It definitely needs polishing. For one thing, probably no one writes Dim a,b,c,d As Integer with the intention of declaring a,b,c as Variants. It would make more sense to skip that part about DimAll and just expand all things that look like Dim a,b,c,d As Integer in the entire project. Ultimately, I would like to figure out how to turn it into a VBE add-in with keyboard shortcuts. I'll look at that link — John Coleman6 mins ago
he's got a point. the inspection/quickfix was implemented to not change what the code is doing. perhaps we could implement another quickfix, a smarter one, for when only the last type is specified.
Option Compare Text
Public Sub Textchecker()
'
' Textchecker
'
' Keyboard Shortcut: Ctrl+h
'
Dim Continue As Long
Dim findWhat As String
Dim LastLine As Long
Dim toCopy As Boolean
Dim cell As Range
Dim item As Long
Dim j As Long
Dim sheetIndex As Long
Dim inclusion As String
sheetIndex = 2
Con...
Just like you have to use a Boolean value to remember when the CTRL key is pressed, and release it when released, just remember when CTRL-R is pressed, and release it on next key release.
There is no built-in control that has a textbox with a [Browse] button beside it. You gotta set that up yourself.
For the "open file" dialog itself, there is the OpenFileDialog in Microsoft.Win32 namespace.
if we had the ability to add a statusbar to the VBE, we'd also have the ability to add a bar with colored notches next to the code pane vertical scrollbar for every inspection result, click-to-navigate, and a little floating icon with a dropdown to select a quickfix
I don't do assembler.
the only code I've seen doing anything remotely similar, is the $$$$$ add-in that lets you walk the VBA stack trace with an API.
I have the following VBA code:
Sub test():
Dim NameValue As String, w1 As Worksheet, w2 As Worksheet
Dim i As Long, j As Long, k As Long, c As Long
Set w1 = Sheets("Sheet2"): Set w2 = Sheets("Sheet3")
GetNameValue: For i = 1 To w1.Range("A" & Rows.Count).End(xlUp).row
If w1.Range("A" &...
I wrote my first WPF UserControl today, and I would like you to review it. Its purpose is to have images by default resize with the page, but expand to full size with a double-click:
<UserControl
x:Class="MyApp.ImageDisplay"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presenta...
I have sales data for rolling 12 months and for each month and I have sales data. I want to write a VB script where I have to take the salesperson opportunity into consideration( if he joined 3 months back then his opportunity is 3 and this field is already present in the excel sheet). I need to ...
In WPF i've added a DataGrid:
<DataGrid x:Name="dataGridProdotti" HorizontalAlignment="Left" Margin="10,56,0,0" VerticalAlignment="Top" Height="250" Width="426" SelectionChanged="dataGridProdotti_SelectionChanged" IsReadOnly="False"/>
with the property
IsReadOnly="False"
Then i do:
dataGri...
You have:
Dim RangeNOut as Double
Dim RangeNOut as Integer
While the IF statements in there are a nice idea, VBA will not allow you to do that. It doesn't do conditional 'compilation' since it isn't a compiled language. When VBA runs your code, all your variables are declared (no matter where ...
In response to this question I thought it would be fun to write a VBE macro that would automatically replace lines which look like
DimAll a, b, c, d As Integer
by
Dim a As Integer, b As Integer, c As Integer, d As Integer
In my first draft I just want to modify a single selected line. After...
Option Compare Text
Public Sub Textchecker()
'
' Textchecker
'
' Keyboard Shortcut: Ctrl+h
'
Dim Continue As Long
Dim findWhat As String
Dim LastLine As Long
Dim toCopy As Boolean
Dim cell As Range
Dim item As Long
Dim j As Long
Dim sheetIndex As Long
Dim inclusion As String
sheetIndex = 2
Con...
There is no built-in control that has a textbox with a [Browse] button beside it. You gotta set that up yourself.
For the "open file" dialog itself, there is the OpenFileDialog in Microsoft.Win32 namespace.
I have the following VBA code:
Sub test():
Dim NameValue As String, w1 As Worksheet, w2 As Worksheet
Dim i As Long, j As Long, k As Long, c As Long
Set w1 = Sheets("Sheet2"): Set w2 = Sheets("Sheet3")
GetNameValue: For i = 1 To w1.Range("A" & Rows.Count).End(xlUp).row
If w1.Range("A" &...
I wrote my first WPF UserControl today, and I would like you to review it. Its purpose is to have images by default resize with the page, but expand to full size with a double-click:
<UserControl
x:Class="MyApp.ImageDisplay"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presenta...
VBA Rubberducking
VBA Rubberducking