Results 1 to 8 of 8

put Text box value into 1st empty space in colum

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    put Text box value into 1st empty space in colum

    YAH im stuck again.

    Got this
    Private Sub PicName_Form_Click()
    
    If PicName_textbox.Text = "" Or Decription_textbox.Text = "" Then MsgBox "Please Enter Picture Name & Short Dicription"
    ''BOTH TEXT PRESENT "NEXT STEEP"
    ''''''''''''''''''''''''''''''''''''''''''''''''
    'if PicName_textbox.Text <> "" And Decription_textbox.Text <> "" Then (A1).Value = "M³"
    ''''''''''''''''''''''''''''''''''''''''''''''''
    If PicName_textbox.Text <> "" And Decription_textbox.Text <> "" Then MsgBox "Photo Has Been Entered Corectly"
    If PicName_textbox.Text <> "" And Decription_textbox.Text <> "" Then Unload Me
    
    End Sub
    Trying to get the value's from PicName_textbox and Decription_textbox and enter the value for PicName_textbox into the 1st empty cell in colum A and Decription_textbox nto the 1st empty cell in colum B.

    Though i only want them transphered if both PicName_textbox and Decription_textbox

    Thank's Again.
    Last edited by D_Rennie; 06-04-2009 at 07:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1