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 &quo
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 w
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 UsuallyReturnsAnA
> b8 2
> > > c9 3
> > > d1 5
> > > e8.51
> > >
> > > I want to put the values (a, b, c, d, e) from the Person
> > > column next to the data point. For exampl
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
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
> termi
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,
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 on
On 12 Mai, 13:22, 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 s
> 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
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 = Wor
On 31 Aug., 03:27, Meimei 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. Does anyone know w
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 publi
On 25 Aug., Mike wrote:
> Thanks in advance!
> 1. I am using MS Excell 2007
> 2. Problem: I have a Column of serial #'s and they are listed low to
> high. Some of the Serial # are listed once, some twice and some 3
> times.
> 3. I want to alternate shading for each set of the same serial #'s.
>
> E
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 e
t; > > name like 7EA78f10 ……and shows a save as dialogue box, when I click on
> > > cancel the above error message is displayed and when I save that file, it
> > > says “Excel has encountered a problem and need to close and it will start
> > > recovering the files agai
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 wan
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
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 chan
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 equ
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 tex
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 fir
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 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 updat
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 th
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)
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 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 using the atta
On 9 Jun., 16:15, Rod Urand 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 determine how many
wLanguageId As Long, _
ByVal lpBuffer As String, _
ByVal nSize As Long, _
ByRef Arguments As Long _
) As Long
Public Const ERROR_BROKEN_PIPE As Long = 109
----------
Code Module "ShellHelper"
-
On 1 Jun., 01:57, donvreug 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 usually have two or
On 30 Mai, 17:55, ayush jain 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 feel free to sha
On 30 Mai, 02:26, donvreug 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 common problem bu
On 27 Mai, 17:08, molinari wrote:
> I have a macro for which I want to eliminate repetitive code. I have
> two sets of sheets, which match in different ways and are
> systematically labelled. There are sheets with numbers 1 to n, which
> also have a postfix "a" or "b". Different things need to b
On 18 Mai, 16:10, Hiren Sheth 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
http://www.vbaexpress.com/kb/getarticle.php?kb_id=250).
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 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", "Mo
38 matches
Mail list logo
