Alteration to VBA Code

**Shazz** · 02-01-2012, 10:13 AM

Can anyone help at all, I have the below codes (Write data to Worksheet & Load Data) which works fine, but I have added Text Boxes and taken away check boxes from my user form, but of course now the code needs alterations and I can not work out what needs to be changed, below are what each of my columns are in the excel spreadsheet that the code needs to write too. I have taken the two check boxes off the form and when i deleted that part on the code it did not work, I am a newby at all this so anyones help is greatly apprecaited.

Column 1 To 12 Text box
Column 13 & 14 ComboBox
Column 15 Text Box
Column 16 & 17 Text Box
Column 18 ComboBox

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Bob Phillips** · 02-01-2012, 10:24 AM

Please Login or Register  to view this content.

**Shazz** · 02-01-2012, 10:29 AM

Thanks for that Bob, Do I copy the below data into the Load Data Code as well.

Please Login or Register  to view this content.

**Bob Phillips** · 02-01-2012, 02:12 PM

Could do, but I would put it in its own procedure and call that from both places.

**Shazz** · 02-01-2012, 05:36 PM

I tried that but the code did not work, would you be kind enough to show me the best way to adapt the below code to suit.

Please Login or Register  to view this content.

Shazz

**Bob Phillips** · 02-01-2012, 07:57 PM

Please Login or Register  to view this content.

Alteration to VBA Code

LinkBack

Thread Tools

Rate This Thread

Display

Alteration to VBA Code

Re: Alteration to VBA Code

Re: Alteration to VBA Code

Re: Alteration to VBA Code

Re: Alteration to VBA Code

Re: Alteration to VBA Code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions