[MafiaAndre]

andrewsw, on 18 February 2013 - 11:33 AM, said:

I hope that modi123_1 won't mind me re-quoting his earlier post, as he states it very well:

Quote

"this code does not work" - how? In what way? Is there an exception? If so what is the text and what line is the exception on? Is it not performing as expected? If so what is it doing/what results is it providing, and what were you expecting? The more you can tell us the better we are at helping you.

and, of course, we would need to see relevant code.

Here is my coding:

oSheet.Range("A5").Value = ComboBox1.SelectedItem.ToString()
        oSheet.Range("A6").Value = ComboBox2.SelectedItem.ToString()
        oSheet.Range("A7").Value = ComboBox3.SelectedItem.ToString()
        oSheet.Range("A8").Value = ComboBox4.SelectedItem.ToString()
        oSheet.Range("A9").Value = ComboBox5.SelectedItem.ToString()
        oSheet.Range("A10").Value = ComboBox6.SelectedItem.ToString()
        oSheet.Range("A11").Value = ComboBox7.SelectedItem.ToString()
        oSheet.Range("A12").Value = ComboBox8.SelectedItem.ToString()
        oSheet.Range("A13").Value = ComboBox11.SelectedItem.ToString()
        oSheet.Range("A14").Value = ComboBox12.SelectedItem.ToString()
        oSheet.Range("A15").Value = ComboBox13.SelectedItem.ToString()
        oSheet.Range("A16").Value = ComboBox14.SelectedItem.ToString()
        oSheet.Range("A17").Value = ComboBox10.SelectedItem.ToString()
        oSheet.Range("A18").Value = ComboBox9.SelectedItem.ToString()

I want to be able to let a combo box or two be left blank at a stage when it is not in use. How can I get rid of the NullReferenceException?

[CharlieMay]

If you're just passing the text that is displayed in the combobox to the cell you could use Combobox1.Text instead of Combobox1.SelectedItem.ToString

This should produce and empty when nothing is selected.

[andrewsw]

You can fill the range in one go:

oSheet.Range("A5:A18").Value = objExcel.WorksheetFunction.Transpose({ _
    ComboBox1.Text, ComboBox2.Text, ... etc..})

- ensure that there are the same number of ComboBox.Text values are there are cells in the range you are filling.

This post has been edited by andrewsw: 20 February 2013 - 01:26 PM

[MafiaAndre]

andrewsw, on 20 February 2013 - 01:24 PM, said:

You can fill the range in one go:

oSheet.Range("A5:A18").Value = objExcel.WorksheetFunction.Transpose({ _
    ComboBox1.Text, ComboBox2.Text, ... etc..})

- ensure that there are the same number of ComboBox.Text values are there are cells in the range you are filling.

I would just like the SaveDialog box thing please? At the moment, I have to specify in my coding where to save it. So it a user downloads my program, and tries to save it, it wont save. Thats why I need a SaveDialog Box...

[torind_2000]

andrewsw kindly provided you with a link to information regarding SaveDialog.

andrewsw, on 17 February 2013 - 05:41 AM, said:

What? The SaveFileDialog

I'd suggest you attempt the following, or some variation of it:

Step 1. Click the link andrewsw gave in his prior post.
Step 2. Read the information.
Step 3. Try some things and see how they work.
Step 4. If you figure it out, great work! Else, post the code with all of your tries so we can see.
Step 5. Read any responses given and answer them clearly and concisely. Provide relevant code if applicable.
Step 6. Stop asking "Gimme teh Codez" and learn.

[MafiaAndre]

torind_2000, on 06 March 2013 - 11:28 AM, said:

andrewsw kindly provided you with a link to information regarding SaveDialog.

andrewsw, on 17 February 2013 - 05:41 AM, said:

What? The SaveFileDialog

I'd suggest you attempt the following, or some variation of it:

Step 1. Click the link andrewsw gave in his prior post.
Step 2. Read the information.
Step 3. Try some things and see how they work.
Step 4. If you figure it out, great work! Else, post the code with all of your tries so we can see.
Step 5. Read any responses given and answer them clearly and concisely. Provide relevant code if applicable.
Step 6. Stop asking "Gimme teh Codez" and learn.

I have tried that coding from the example in the link, but I do not know HOW to implement it.... I tried to copy and past it, and debug it, but no Dialog opened...

[andrewsw]

If you just copied and pasted the code, without understanding it, then it is not surprising that it didn't work. You need to read and study the information in the linked-page so that you can incorporate the example into your own code. If you do this and it still doesn't work then you could come back here, post your code, and someone will probably give you some guidance.

If you don't wish to study, and understand, the code then you might consider employing someone to create the code you need.

[MafiaAndre]

andrewsw, on 07 March 2013 - 11:12 AM, said:

If you just copied and pasted the code, without understanding it, then it is not surprising that it didn't work. You need to read and study the information in the linked-page so that you can incorporate the example into your own code. If you do this and it still doesn't work then you could come back here, post your code, and someone will probably give you some guidance.

If you don't wish to study, and understand, the code then you might consider employing someone to create the code you need.

I have tried to understand it, and I have asked questions to help me understand, but I still asked where is the coding that I already have to save all the comboboxes, and no one answered me... Everyone answered other stuff...

[modi123_1]

Quote

[but I still asked where is the coding that I already have to save all the comboboxes,

I thought you had that working in post 9.

[CharlieMay]

No, he has a static line to save, he's wanting to prompt the user with the save file dialog so that from that he can get the

AHEM!!!
SaveFileDialog's .FileName property that returns a string of the path & file to put in place of the string he's specifying