Evaluate textbox and display in Format

I'm not certain, but try this

Private Sub drum_weight_AfterUpdate()
With Me.drum_weight
       .Value = Evaluate(.Value)
        .NumberFormat = "$#,###.00"
End With
End Sub

Originally Posted by ptmuldoon

I'm not certain, but try this

Sorry but didn't work...says "Method or data member not found

Can you post a sample then to help troubleshoot?

unable to upload the attachment although I have the same workbook...

Its simple.. i just made the user form with two list boxes...

and assigned my code the first one...

it should be simple...
meanwhile i will try again

tried in two different browsers.. the attachment icon is not working

Capture.JPG

Tried attaching an image ... of the sample file.... hope this opens and u can see what I did... you can open new excel sheet.. hit ALT F11 and create a userform with two list boxes. and use the code I posted above (make sure the list box name is same as mentioned)

Originally Posted by subbby

tried in two different browsers.. the attachment icon is not working

You need to "Go Advanced" to add the attachment.

Originally Posted by ptmuldoon

You need to "Go Advanced" to add the attachment.

I was kind fo expetcing that resposnse.. all my tries were , after I hit the "GO ADVANCED" option

here is how that looks when I try to upload an attachment buddy


Capture2.JPG

Scroll down the page where is say Manage Attachments.

Originally Posted by ptmuldoon

Scroll down the page where is say Manage Attachments.

and then do what ?

Although i was able to add the attachment... i wasn't able to bring it to the post ..
do u have a solution ?



Capture3.JPG

Subbby

After you attach the file, you just close the attachment window and it will return you to your post with the attachment. I can't see what could be causing you to not be able to attach something.

I tried again... went to manage window.. attached the excel.... pressed the upload option... close the window, cam e back here and I see no attachment...

however I am posting this... just to see if the attachment goes thru

SOLVED

used the following code....

       .Value = Format((Evaluate(drum_weight.Value)),"#,#")

instead of

 .Value = Format((Evaluate(.Value)),"#,#")

let me try from a different computer ....

Thanks for your patience