Results 1 to 7 of 7

Thread: Creating two buttons and code programmatically

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-02-2005, 11:59 AM #7
    Paleo
    Paleo is offline
    Administrator
    VP-Knowledge Base     VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location

    Ignore this one, just read the previous.

    This one is already solved, just read the previous, please.

    This is the one I wanna change and t has another error. Two buttons are being positioned one above another. The ones from column "B".


    For Each cl In [B5664,B5668,H5664] 'update this range to place buttons
i = i + 1
Set myCmdObj = TargetSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", _
Left:=cl.Left + 1, Top:=cl.Top + 1, Width:=202.5, Height:=32.25)

    Any suggestions about this thread and the one before it?
    Last edited by Paleo; 02-02-2005 at 12:03 PM. Reason: Solved
    Best Regards,

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules