+ Reply to Thread
Results 1 to 2 of 2

Applying TextBox Values to a String

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-24-2010
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    195

    Applying TextBox Values to a String

    Hey folks,
    Can anybody offer any Advice on this piece of code?
    Ite returning a 'RunTime Error '424': Object Required

    Dim NoDate As Boolean
    ------------------------------------
    
    
    Sub DateField()
    
    If TextBox1.Value = False Then
    MsgBox ("Enter This Weeks Date")
    NoDate = True
    Exit Sub
    Else
    strDate = TextBox1.Value
    End If
    
    
    End Sub

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,299

    Re: Applying TextBox Values to a String

    Where is the code and do you have a control called Textbox1?
    Anyone who confuses correlation and causation ends up dead.

+ Reply to Thread

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