Here is some info I found on wikipedia.
The most famous exponent remains legendary bassist Jack Bruce of Cream. John Entwistle of The Who also played one briefly in the early '60's. Eric Haydock of The Hollies is another famous Fender Bass VI user.
A Fender VI can also be seen on Beatles' videos for "Hey Jude", "Let it Be", and "The Long and Winding Road". It was played by both George Harrison ("Hey Jude"- though Paul McCartney played bass on the single version) and John Lennon ("Let It Be", "The Long and Winding Road") when the band's bass player, McCartney, played piano.
Peter Green made extensive use of the Fender VI as a solo instrument during his live performances of 'The Green Manalishi' with Fleetwood Mac from 1969-1970, and also as a session musician with Duster Bennett (AKA 'Peter Blue') and Peter Bardens, among others.
Years later, the Fender VI was embraced by Robert Smith from The Cure. Originally a guitarist, Smith uses the Fender VI as a lead instrument, playing phrases and even chords on it. The Fender VI can be heard on songs such as "Pictures of You" and "Lullaby".
Jet Harris used a Fender Bass VI as a solo instrument on a string of British instrumental singles like "Besame Mucho" in 1962. It was also used as lead instrument on the hit record "Scarlet O'Hara" by Jet Harris and Tony Meehan in 1963.
Rick Danko of The Band made use of a white Bass VI while backing Ronnie Hawkins in The Hawks, though by the time the Hawks were with Bob Dylan, Danko had switched to a Fender Jazz Bass
It was also used by Saul Davies of the band James, as a lead instrument (visible in the concert video "Getting Away With It" on the songs "Someone's Got It In For Me," "Getting Away With It," and "Vervacious"), and Stefan Olsdal of Placebo. Mark Hoppus from blink-182 also used a Fender VI on their untitled CD. During the infamous "Don't touch it" scene of Spinal Tap Nigel's extremely special guitar is actually an original foam green Fender VI.
It is the only bass John Lowery plays on his solo works (though guest musicians often play their own).