User Profile

Collapse

Profile Sidebar

Collapse
esperanto234
esperanto234
Last Activity: May 9 '10, 07:07 AM
Joined: Sep 3 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • esperanto234
    started a topic Repete this code for every row
    in Visual Basic

    Repete this code for every row

    Hi, I have this code to lock some cells if date has passed:

    Code:
    If [MARCADORES!E3] <= Date Then
ActiveSheet.Unprotect ("mundial")
ActiveSheet.Range("MARCADORES!I3:T3").Locked = True
ActiveSheet.Protect ("mundial")
Else
ActiveSheet.Unprotect ("mundial")
ActiveSheet.Range("MARCADORES!I3:T3").Locked = False
ActiveSheet.Protect ("mundial")
    ...
    See more | Go to post
    • esperanto234
      started a topic Print from Word doc. between bookmarks
      in Visual Basic

      Print from Word doc. between bookmarks

      Hi, i need a VBA code for printing between bookmarks in a Word doc

      I also need to change 2 printing options:

      1) Print from Tray 3
      2) Print in both sides of the paper

      Thank you very much
      See more | Go to post
      • esperanto234
        started a topic Fill Userform From Database
        in Visual Basic

        Fill Userform From Database

        Hi, This is the Ultimate Question!!!

        I already finished my program in VBA, it has a userform for filling data into Word.

        It has a bunch of textboxes.

        But people has to fill de information into the textboxes every time they open the userform. Information that is already in a databse in excel.

        My question is: How can i do to fill automatically some textboxes in the userform, when it's open,...
        See more | Go to post
        • esperanto234
          replied to Remove Unselected Items from listbox
          in Visual Basic
          Thank you very much, I already did it.

          In case someone wants to know, the answer is the following:...
          See more | Go to post

            Leave a comment:

          • esperanto234
            started a topic Remove Unselected Items from listbox
            in Visual Basic

            Remove Unselected Items from listbox

            Hi,
            I need a code to remove all the items that are unselected from a listbox.
            I really need this!!
            Thanks!!
            See more | Go to post
            • esperanto234
              replied to From textBox To Listbox
              in Visual Basic
              Thank you very much, I used the initialized event in the other form and it works perfectly....
              See more | Go to post

                Leave a comment:

              • esperanto234
                replied to From textBox To Listbox
                in Visual Basic
                The event is change, and with the other events is the same thing!! HELP PLEAASEEE...
                See more | Go to post

                  Leave a comment:

                • esperanto234
                  started a topic From textBox To Listbox
                  in Visual Basic

                  From textBox To Listbox

                  "HI! im using the following code to fill a listbox from a textbox

                  Code:
                  Dim strNMBCY As Long
                  strNMBCY = Len(UserForm1.t xtNMB)

                  If strNMBCY > 1 Then
                  UserForm2.ListB ox1.AddItem UserForm1.txtNM B
                  UserForm2.ListB ox2.AddItem UserForm1.txtNM B
                  End If

                  The problem is that it fills in a strange way Ex:
                  If I write in the textbox = Phill
                  It shows in the listbox...
                  See more | Go to post
                  • esperanto234
                    replied to Listbox Strings to word
                    in Visual Basic
                    Listbox to word




                    Thaks, im using vb6, i need to insert only items that are checked. Could you please send me the code? thanks...
                    See more | Go to post

                      Leave a comment:

                    • esperanto234
                      replied to text stay on top
                      in Visual Basic .NET
                      Hi, i solved the problem using: insert, the the first option (my office is in spanish). Thanks anyway
                      See more | Go to post

                        Leave a comment:

                      • esperanto234
                        replied to Listbox Strings to word
                        in Visual Basic
                        HI, THANKS FOR THE REPLY
                        Here's what i have
                        Code:
                        Dim str1 As String
   Dim i As Integer
   Dim s As String

   With ListBox1
       For i = 0 To .ListCount - 1
           str1 = str1 & s & .List(i)
           s = ", "
           If i = .ListCount - 2 Then s = " y "
       Next i

       Debug.Print str1
   End With
ActiveDocument.Bookmarks("p91").Range.Text
                        ...
                        See more | Go to post

                          Leave a comment:

                        • esperanto234
                          started a topic text stay on top
                          in Visual Basic .NET

                          text stay on top

                          I have a document with 3 pages and with VB I always insert text in page 1.
                          The problem is that the text in page 2 always goes down when text in page 1 is inserted.

                          My question is: How can i do to make the text in page 2 always stay at the top of the page,
                          and if it haves too, move down one page but always staying at the top.
                          See more | Go to post
                          • esperanto234
                            started a topic Listbox Strings to word
                            in Visual Basic

                            Listbox Strings to word

                            Hi, Im using alistbox to insert names in a word document, im' using the following code but it only inserts the first ITEM on the list.


                            Code:
                            Code:
                            Dim strList1 As String
strList1 = ListBox1.List(ListBox1.ListIndex)
ActiveDocument.Bookmarks("p91").Range.Text = strList1
                            My question is: How can i do to insert ALL items in the listbox in word. I need them to be separated by comas and the...
                            See more | Go to post
                            Last edited by Frinavale; Sep 9 '09, 08:21 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.
                            • esperanto234
                              started a topic From Listbox to Word
                              in Visual Basic

                              From Listbox to Word

                              Hi, Im using alistbox to insert names in a word document, im' using the following code but it only inserts the first name.


                              Code:
                              Dim strList1 As String
                              strList1 = PODERES.ListBox 1.List(PODERES. ListBox1.ListIn dex)
                              ActiveDocument. Bookmarks("p91" ).Range.Text = strList1


                              My question is, how can i do to insert ALL items in the listbox in word, the thing is i need them to be...
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...