+ Reply to Thread
Results 1 to 2 of 2

Coding problem please help.

  1. #1
    Registered User
    Join Date
    04-19-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    1

    Question Coding problem please help.

    hi there, I've run into a problem that I am unable to fix and need some help because I am a beginner. Basically ive been running a code for form filling that allows the correct option box to apply an "x" onto the form and its worked fine for previous forms, however on this form using the exact same code I run into "runtime error 438" with this piece of code highlighted in yellow, Sheets(2).Range("E63").Value = "x"
    This is the full code I've been using

    Private Sub CommandButton2_Click()
    If Unit151.Frame6.OptionButton16.Value Then
    Sheets(2).Range("E63").Value = "x"
    ElseIf Unit151.Frame6.OptionButton17.Value = True Then
    Sheets(2).Range("F63").Value = "x"
    Else
    Sheets(2).Range("G63").Value = "x"
    End If
    End Sub

    Any help or suggestions would be helpful thank you.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Coding problem please help.

    Hello & Welcome to the Forum,

    Your post does not comply with Rule 3 of our Forum RULES.

    Use code tags around code.

    Your post does not comply with Rule 1 of our Forum RULES

    Your post title should accurately and concisely describe your problem, not your anticipated solution.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check multi level username with password
    By Shunwen82 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2015, 11:00 AM
  2. Coding Problem
    By Shazz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2012, 03:55 AM
  3. Coding Problem
    By skin.uk1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 11:38 AM
  4. If, Then, Else Coding Problem
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2006, 03:30 PM
  5. Please help: Coding Problem
    By Tim in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-28-2005, 01:05 AM
  6. [SOLVED] Coding problem
    By John in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2005, 01:05 PM

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