Posts by Reafidy

Re: Making a check box return "yes" or "no" instead of true false

It all depends what you are doing with the yes/no. When you want to assign the result to a variable then just use this:

Private Sub DoSomething()
    Dim sChkBoxResult As String
    
    '//  Your code ....


    sChkBoxResult = IIf(CheckBox1.Value, "Yes", "No")
  
End Sub

Alternatively you could use something like this:

Private sChkBoxResult As String


Private Sub UserForm_Initialize()
    sChkBoxResult = "No"
    CheckBox1.Value = False
End Sub


Private Sub CheckBox1_Change()    
    sChkBoxResult = IIf(CheckBox1.Value, "Yes", "No")  
End Sub


Private Sub CommandButton1_Click()
    MsgBox (sChkBoxResult)
End Sub

Re: Make a Sort button

oscar42,

As per the forum rules, start your own thread if you have a question. Please make sure you read the rules as you have also not used code tags for posting your code.

Re: $135 / week - problem with not knowing enough

Sorry but I wasn't actually putting my name in the hat. I was just trying to get more info for others.

Taylor - Normally the hire help forum works on a "first to reply gets the work" arrangement. However because of your specific requirements you may need to select the appropriate developer yourself or a trial bases as you mentioned - up to you, we have some excellent developers here at ozgrid - good luck with your project.

Re: $135 / week - problem with not knowing enough

For this kind of hire help, it would help to know what time zone you are in and what times you require support.

Re: Populate Worksheet and Labels Based On User Input Box

Thank you.

Re: Populate Worksheet and Labels Based On User Input Box

Why not post your solution for the benefit of others?

Re: Help With Input Boxes

Please read the rules. On the page you typed your thread title it clearly states:
3. DO NOT USE WORDS LIKE "HELP", "PLEASE", "I NEED" OR "HOW DO I" IN YOUR THREAD TITLE.

Re: Change label caption within user form

Set the labels caption property in the form initialize event.

Please read the rules regarding code tags and thread titles. On the page you typed your thread title it clearly states:
3. DO NOT USE WORDS LIKE "HELP", "PLEASE", "I NEED" OR "HOW DO I" IN YOUR THREAD TITLE.

Re: How to store and copy a formula to specific or range of cells?

You can store the formula to a string. Then simply add it back to your worksheet where you want it.

FOr example this code stores the formula from cell B1 and then adds it to cells B2:B11:

Dim sFormula As String




sFormula = Cells(1, "B").Formula




Cells(2, "B").Resize(10).Formula = sFormula

Re: $50.00 - Download data from protected Internet page

Quote from watergate74;584126

No, I don't think that this work.

Okay, was worth a shot. Project is all your's norie.

Re: Vlookup

Thread titles are important at Ozgrid. Please edit yours to accurately and concisely define your problem.

Re: $50.00 - Download data from protected Internet page

IS it not just a case of adding the username and password?

xmlhttp.Open "POST", sURL, False, "Username", "Password"

Re: UserForms with multiple monitors

Thanks lackllogic,

As you mentioned, it doesn't matter how old the thread is, new solutions are always welcome. Software and hardware change over time as so do solutions, plus new solutions can be discovered. This thread will show up in many searches and could possibly provide help to thousands of people...

Re: Non-activex Datepicker Calendar Control

This thread is getting far to many questions (thread hijacking). If you have questions please start your own thread and if required add a link back to this thread.

Thread closed.

Re: Office 2011 for Mac Dictionary replacement

I'm sure that will definitely help out some Mac users. Thanks!

Re: extract numeric data from alphanumeric rows using VBA / macros ?

Turkey,

I'm very sorry our forum did not meet with your expectations of FREE help and that you struggle to follow simple forum rules. Good idea, I have sold your email address to spammers as requested. Thank you for your kind comments.

Re: extract numeric data from alphanumeric rows using VBA / macros ?

Thanks Mike.

Re: Help with getting a VBA program to run

dnivra,

Please read the rules before posting here again.

Immediately above the box you typed your thread title it clearly states: 3. DO NOT USE WORDS LIKE "HELP", "PLEASE", "I NEED" OR "HOW DO I" IN YOUR THREAD TITLE.

Re: Hook into Google MAPS API

Its still wrong, I presume this is the link you are trying to post: http://ramblings.mcpher.com/Home/excelquirks/getmaps

Re: Excel to VB

Quote from Leslye;580802

And please dont yell at me if this post/request is wrong... I just started today after all. im just looking for help.

That is no excuse for not bothering to read and familiarise yourself with the rules. Please be sure do so before posting again. You have neglected to use code tags.