+ Reply to Thread
Results 1 to 2 of 2

How can i convert this to vba code

  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    How can i convert this to vba code

    Hello,

    How can i convert the below statements to vba code?

    I just want:

    if Checkbox1 is check and B2 is empty or equal to zero then
    B2 = Label1

    If Checkbox1 is uncheck and B2 is empty or equal to zero then do nothing

    If B2 is not empty or has a data on it, then a msgbox will prompt "Data already exists".

    Appreciate your prompt reply.

  2. #2
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: How can i convert this to vba code

    Hello,

    Something like this siobeh ?
    Please Login or Register  to view this content.
    Harry.

+ 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. [SOLVED] VBA code - Convert one value to another value
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2012, 12:18 PM
  2. How To Convert VBA Code To DLL/XLL?
    By CaliKidd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2011, 11:19 AM
  3. VBA Code to Convert xls to pdf
    By LoveCandle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2009, 05:38 AM
  4. Convert VBA code to VB.NET
    By Sam Kelly. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2005, 05:45 AM
  5. Convert Zip Code to County
    By Michael in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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