Display the Output in Textbox

[Biplab1985]

Hello,

I am trying to get the ouput in textbox8 but i am getting it the cell. Can anyone please help

Please Login or Register  to view this content.

[simarui]

this seems to be working.

Please Login or Register  to view this content.

mostly stolen from:
http://stackoverflow.com/questions/2...et-the-formula
which has an alternative solution as well. also, here's a nifty trick for determining the size of the textbox based on the location of individual cells if you don't like the 100, 100, 200, 50 method:
http://stackoverflow.com/questions/6...tomating-excel

[Biplab1985]

It is not working. I need to just display the output in Text box8

[simarui]

is the text box named "Text box8" or is it the eighth textbox...? maybe this would work:

Please Login or Register  to view this content.

or perhaps

Please Login or Register  to view this content.

[Leith Ross]

Hello Biplab1985.

To help you get a solution, you need to provide more details. The best way to do this is by posting your workbook.

Please change or redact any information in your workbook that is personal, confidential, or sensitive before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[Biplab1985]

Still not working. File attached the code is in Module1

[simarui]

how bout this:

Please Login or Register  to view this content.

p.s. looks like you've got a textbox8_change event which is trying to run and blows everything up... i commented that out to make this work. not sure what you were trying to accomplish there.

[Biplab1985]

The textbox8_change event is to call Columntorow function. There is a optionbutton associated with that Textbox8. What i want to acheieve is - If the Option Box is checked/True Textbox8 will CALL Columntorow funtion.

Thanks for the change in the previous code. It worked but Textbox8_Change is unable to Call Columntorow function of module.

Please Login or Register  to view this content.

[Biplab1985]

I got it! Instead of Textbox8_change event i used theOptionButton_Click and i worked as i wanted. Thanks Simarui for all you help. I come back for more.

Please Login or Register  to view this content.

[simarui]

glad i could help, don't forget to mark the thread solved

[Biplab1985]

I am getting an comma(,) in the begining of the output like-

,1,2,3,4. It should not come right?. Please help!

[simarui]

the code i wrote shouldn't add any commas... did you change your workbook and the associated code? please re-upload your most recent sample file.

[Biplab1985]

This is the code i am using here

Please Login or Register  to view this content.

[Biplab1985]

Sheet attached. COde is in Module1

[Biplab1985]

Hi Simarui,

Any input?

[simarui]

how 'bout if you just move the comma to the end of that statement:

Please Login or Register  to view this content.

actually that will just add a comma to the end of the string which you probably also don't want (i.e. 1,2,3,4,5,)

how bout this:

Please Login or Register  to view this content.

[Biplab1985]

One mOre Help.

I am looking for a code to keep updating a textbox whenever you add any data to a column "O". Code is below. I am calling this code witha Option Button