On Oct 12, 2011 Stuart Redmann wrote:
Hello newsgroup,
I tried the following code to create an ActiveX checkbox under Excel:
- Create new workbook.
- Add following code to worksheet 1
Sub test()
Me.Shapes.AddOLEObject Forms.CheckBox.1, , False, False, , , ,
100, 100, 100, 100
Hello newsgroup,
I tried the following code to create an ActiveX checkbox under Excel:
- Create new workbook.
- Add following code to worksheet 1
Sub test()
Me.Shapes.AddOLEObject Forms.CheckBox.1, , False, False, , , ,
100, 100, 100, 100
End Sub
- Execute code
Now I have got a worksheet
On 7 Sep., ShayneH wrote:
Is there a way to expose an array that is enclosed by a variant?
Basically I have one function that returns a variant type which needs
to be passed to another procedure that requires the parameter to be
typed as a byte array.
eg:
Function UsuallyReturnsAnArray()
On 6 Aug., Excel 009 wrote:
Hi All,
I have the following data and want to create a scatter chart. I am
using either 2003 or 2007.
Person X1 X2
-- --- ---
a2 4
b8 2
c9 3
d1 5
e
5
e8.51
I want to put the values (a, b, c, d, e) from the Person
column next to the data point. For example, d for
the (1,5).
On August 09, Stuart Redmann wrote:
You can do the following workaround: Make the chart an ordinary
XYScatter chart and add one
On 3 Aug., Rruffpaw wrote:
I have a very large Excel spreadsheet (13 MB) with several macros. One
of them runs a loop with multiple commands.
The macro runs fine, as long as I sit back and just watch it run. If I
click on another window however, it invariably freezes and I have to
terminate
On 1 Aug., bpascal123 wrote:
Hi all Experts,
Below is the code I produced following my learning of vba for Excel
from excelvbasql.com. I would like to know if there is anything to be
done about this code. I'm looking to learn from anyone who can share
his/her experience.
Cheers,
The
On 12 Mai, Born to Win wrote:
Hi Experts,
in attached excel file you can see contact no. along with many services
activated on a single no. you can find it in separate entry i am trying to
write a VB program so that i would have unique no. services (column wise)
in new sheet in one
On 12 Mai, 13:22, Born to Win cs4...@gmail.com wrote:
Hi Experts,
in attached excel file you can see contact no. along with many services
activated on a single no. you can find it in separate entry i am trying to
write a VB program so that i would have unique no. services (column wise)
On Feb 15, BJthebear wrote:
I have written a sub routine to add a name to a dynamic list but I
have three problems with it and would be grateful for some advice.
Sub InputNewUser()
Dim Newuser As String
Dim nextRow As Long
[snipped some code]
'Ask for name of new user
On 23 Sep., cyber 1000s wrote:
Hi cyberspace,
I have some c programming background...
Is it possible to increment a worksheet object (worksheets collection)
in a loop such as below ?
Public Sub CopyShNamesFromWkbToWkb2()
Dim i As Integer
Dim wkb As Object
Set wkb =
On 31 Aug., 03:27, Meimei xxu8810...@gmail.com wrote:
I am writing a simple vba program. I used a few comboboxes in the
program. But I found that as I click on the combobox, the font size in
the drop-down list gets smaller each time, and after a few clicks, the
font is too small to even see.
On 28 Aug., Ayush wrote:
Its a very handy tool for any data analysis and reporting. - Ayush
Jain
---
Guyzzz, Let me know why you like excel so muchThe best response
will be published
Kurt wrote:
I am trying to duplicate the sort feature used in this tutorial:
http://www.contextures.com/xlSort02.html
The description of the first part of the code suggests that the code
creates the invisible rectangles, but I couldn't get it to do this.
What did you do? What kind of error
and when I save that file, it
says “Excel has encountered a problem and need to close and it will start
recovering the files again.
Please help me out
Thanks…
On Jul 20, Stuart Redmann wrote:
This error message indicates that something very fundamental is going
wrong. Usually you
Hi Nadine,
I've sent you an email with a file that hopefully does what you want.
Please don't answer by email, since I have a quite selective spam-
filter. Please post to this newsgroup instead. Thanks.
Stuart Redmann wrote:
I guess that what you wanted to say is that you want to
get the sum
Nadine S wrote:
I have a worosheet with cokumns for 20+ payments.
Please, if you want to get help from others, make sure that your
posting is not full of typos. It makes reading quite hard.
These columns track the date
it was entered for payment, amount, check date, record number for each of
sudhir kumar wrote:
hi friend,
i attached an excel file, which having some information in it, now i want
that if i will do any type of change in it, i will be able to trace it,
means, i change in some of the column or row, or i introduce any new row ,or
delete any row. every type of change i
Santiago Afonso wrote:
Hello. I'd like to use the equation editor in excel 2010 through VBA. In
Word, the equation object is OMath (
http://msdn.microsoft.com/en-us/library/bb256563%28office.12%29.aspx), and
the macro recorder records some actions done to such an object (like
changing
flebber wrote:
I have a column containing cells which house several delimited values
and a dollar value. I want to be able to remove the delimited values
and leave the dollar value in the cell in currency format.
the cells contain information similar to
22-7-4-7 $22400.10
If this text is
On 20 Jul., larry wrote:
I have a macro where I copy data into an array from one sheet and then
post it in another sheet and there is something odd. .8 becomes ,
79, .15 becomes .1501. The other way around this would be
rounding. It only changes the values in the first column.
On 19 Jul., mohd ateeq wrote:
HI all,
Can anyone help me out with the following error:
Run-time error ‘-2147417848 (80010108)’:
Automation error
The object invoked has disconnected from its clients
It occurs when I create around 30-40 new excel files based on some criteria
and update as
On 20 Jul., 14:26, larry wrote:
I have a macro where I copy data into an array from one sheet and then
post it in another sheet and there is something odd. .8 becomes ,
79, .15 becomes .1501. The other way around this would be
rounding. It only changes the values in the first column.
On 5 Jul., dtenz wrote:
I have name cells A1 to D1 as Number Num1 Num2 and Num3.
What? The cells A1 to D1 contain _four_ values. How do they correspond
to Num1, Num2, and Num3? Please be as precise as possible.
Now I have
data in Col A from A1 to around A500 depending on the file. What I
On 30 Jun. Kurt wrote:
1. The comment in this code has as an example, ShadeAlternateRows
Range(A1:D50), 27, 2, but where in the actual code do you put this
information?
Stuart Redmann wrote:
That depends on when the highlighting should happen.
Kurt wrote:
I'm most interested
On 29 Jun., Kurt wrote:
I would like to highlight every other row in a range (A5:L40).
I've seen lots of macro samples to shade alternate rows, but can't get
any to work.
For example, I found this one:
Sub ShadeAlternateRows(rngTarget As Range, intColor As Integer,
lngStep As Long)
[snip]
On 10 Jun.schouw wrote:
How do I define and implement an interface in VBA?
I would like to keep the implementation flexible but the interface
should stay stable.
See http://msdn.microsoft.com/en-us/library/aa165323(v=office.10).aspx.
I've never checked out this feature of VBA, but it will
On 10 Jun., 14:14, Rod Urand urand...@gmail.com wrote:
Stuart,
Thank you for going to all the trouble to build this. I do have a
problem. I just found out that they are indeed free floating
checkboxes that are not attached to cells.
Are we just out of luck here?
Not at all, I was just
On 9 Jun., 16:15, Rod Urand urand...@gmail.com wrote:
I have a client who has created a rather large Excel workbook with
checkbox form controls.
Unfortunately, each form control was not set to have a cell link.
The client would like to now tabulate the results of the checkboxes
(to
://www.bigresource.com/Tracker/Track-vb-XYs37h2gvm/
and modified
'
' History:
' 2010-06-07: Stuart Redmann
' - Added time-out for reading from the pipe.
' - Added parameter ShouldDisplayWindow which decides
whether the
' windows of the launched app is visible.
Option
On 1 Jun., 01:57, donvreug donvr...@gmail.com wrote:
The environment this is occuring in is a corporate one where there are
a number of Excel workbooks each with VBA modules that are deisgned
for different tasks. Occassionally someone tells me a macro has
failed, and when I check they
On 30 Mai, 02:26, donvreug donvr...@gmail.com wrote:
Some of the macros I have written sometimes do not function correctly
if another instance of Excel is open. The other instance usually also
contains macros that may or may not have been executed. I thought I
read somewhere that this is a
On 30 Mai, 17:55, ayush jain jainayus...@gmail.com wrote:
Dear Group,
Thanks for all your contribution to group. The group recently achieved a
milestone of 7000 members. On this occasion, we would like to take your
feedback and suggestions about the group.
This is an anonymous survey , so
On 18 Mai, 16:10, Hiren Sheth hiren.sh...@viteos.com wrote:
Hi,
Is it possible that a sub procedure will do certain steps and at the end it
will delete itself.
Seems to be a strange question but is it possible?
It certainly seems so (see for example
Hello newsgroup,
I have a simple Class module called TestClass that defines an array
property:
TestClass.cls:
Private InternalArray(0) As Double
Public Property Get MyArray() As Double()
MyArray = InternalArray
End Property
Public Property Let MyArray(NewValue() As Double)
InternalArray(0)
On 5 Mai, 11:18, Andy andyr...@hotmail.co.uk wrote:
Heya,
It's as simple as the subject states but I can't seem to find an
answer anywhere.
My code at the moment is:
Worksheets(Array(Sat EEA, Sun EEA, Mon EEA, Tue EEA, Wed
EEA, Thu EEA, _
Fri EEA, Sat NonEEA, Sun NonEEA, Mon
36 matches
Mail list logo